b542fa1 | Marc G. Fournier | 18 April 1998, 18:32:44 UTC | From: Peter T Mount <patches@maidast.demon.co.uk> This fixes a problem in ResultSet.getDate() when the column is NULL (reported by Vincent Partington <Vincent.Partington@nmg.nl>) And fixes a problem with Field's (ResultSet.getObject() was proving to be slow as it repetedly send queries for oid -> name mapping - fixed by creating a cache. (reported by Mario Ellebrecht <ellebrec@nads.de>) | 18 April 1998, 18:32:44 UTC |
87d96ed | Bruce Momjian | 17 April 1998, 14:54:16 UTC | UPdate TODO list. | 17 April 1998, 14:54:16 UTC |
323fefd | Bruce Momjian | 17 April 1998, 04:12:56 UTC | Update HISTORY/TODO. Disable HAVING. | 17 April 1998, 04:12:56 UTC |
09b15ff | Thomas G. Lockhart | 17 April 1998, 03:58:11 UTC | Use POSTGRESDIR to set initial PGDOCS destination directory. PGDOCS in Makefile.custom will supercede defaults here, I think... | 17 April 1998, 03:58:11 UTC |
5a641d4 | Thomas G. Lockhart | 17 April 1998, 03:56:08 UTC | Update info to reflect success on Alpha/Linux and Alpha/DUnix ports. | 17 April 1998, 03:56:08 UTC |
a0ca95f | Thomas G. Lockhart | 17 April 1998, 03:55:01 UTC | Fix typos in a couple of examples. | 17 April 1998, 03:55:01 UTC |
83fd305 | Marc G. Fournier | 17 April 1998, 03:06:35 UTC | A few minor mods: gram.c updated scan.c updated ecpg/Makefile added LDFLAGS configure requires sfio for those systems with it installed... | 17 April 1998, 03:06:35 UTC |
19d41d4 | Marc G. Fournier | 17 April 1998, 02:44:01 UTC | From: Darren King <darrenk@insightdist.com> This will force the aix compiler to insert trapping code to check for division by zero for the 4.1 port. | 17 April 1998, 02:44:01 UTC |
2219c23 | Marc G. Fournier | 17 April 1998, 01:55:31 UTC | Get rid of the TEMPLATE verbosity and make it so that --with-template is documented in ./configure --help | 17 April 1998, 01:55:31 UTC |
8973192 | Marc G. Fournier | 17 April 1998, 01:30:21 UTC | From: Brook Milligan <brook@trillium.NMSU.Edu> Here is a pair of patches that (I hope) finish the configuration issues with tcl/tk and make the recognition of the two packages completely parallel in organization. This should make future changes easier to maintain. Hope to see this in 6.2.2. | 17 April 1998, 01:30:21 UTC |
34299b4 | Marc G. Fournier | 15 April 1998, 21:56:54 UTC | From: David Hartwig <daveh@insightdist.com> Marc, I overlooked this file it should be included in the source. Oops Also the binary file is only 1.2 meg not 2.5 meg. Oops again. | 15 April 1998, 21:56:54 UTC |
4a333c4 | Bruce Momjian | 15 April 1998, 16:50:32 UTC | Update FAQ. | 15 April 1998, 16:50:32 UTC |
7d03bb4 | Bruce Momjian | 15 April 1998, 16:44:36 UTC | pgintro now has a list of all manual pages. | 15 April 1998, 16:44:36 UTC |
5529b78 | Bruce Momjian | 15 April 1998, 15:29:57 UTC | Move HAVING function to proper file. | 15 April 1998, 15:29:57 UTC |
11c0912 | Edmund Mergl | 14 April 1998, 21:14:52 UTC | 1.7.3 | 14 April 1998, 21:14:52 UTC |
1957f24 | Bruce Momjian | 14 April 1998, 03:28:50 UTC | Update gram.c.nd *.h files. | 14 April 1998, 03:28:50 UTC |
27c490b | Bruce Momjian | 14 April 1998, 01:52:47 UTC | Update gram.c scan.c. | 14 April 1998, 01:52:47 UTC |
8eb08ae | Bruce Momjian | 13 April 1998, 21:07:15 UTC | Cleanup up code. | 13 April 1998, 21:07:15 UTC |
0435ecf | Bruce Momjian | 13 April 1998, 16:34:48 UTC | What was LINUX_ELF doing in there? | 13 April 1998, 16:34:48 UTC |
9e3382d | Marc G. Fournier | 13 April 1998, 15:02:05 UTC | Replace old PostODBC driver with new one... This one is based on an older PostODBC driver, rewritten and maintained by InsightDist(?) | 13 April 1998, 15:02:05 UTC |
d4d26f9 | Marc G. Fournier | 13 April 1998, 14:46:48 UTC | From: Diab Jerius <dj@pelf.harvard.edu> Fix for Solaris/cc problem | 13 April 1998, 14:46:48 UTC |
66feaef | Bruce Momjian | 12 April 1998, 14:17:40 UTC | New book to FAQ. | 12 April 1998, 14:17:40 UTC |
07e3fb0 | Marc G. Fournier | 12 April 1998, 02:58:22 UTC | More work in the right direction on linux/alpha From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu> | 12 April 1998, 02:58:22 UTC |
5da68b9 | Bruce Momjian | 12 April 1998, 01:18:35 UTC | Fix for PROFILE env. | 12 April 1998, 01:18:35 UTC |
a362212 | Marc G. Fournier | 11 April 1998, 21:14:50 UTC | linuxalpha patches from Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu> | 11 April 1998, 21:14:50 UTC |
afdc54a | Marc G. Fournier | 10 April 1998, 22:07:41 UTC | Oops...I used Relation->rd_fd->relname exactly, instead of using the actual variable name *blush* *grin* | 10 April 1998, 22:07:41 UTC |
57a40ab | Marc G. Fournier | 10 April 1998, 21:59:30 UTC | Okay, add relation name to the file generating the error... | 10 April 1998, 21:59:30 UTC |
0b746a7 | Marc G. Fournier | 10 April 1998, 18:43:30 UTC | See if I can determine where the BTP_CHAIN error is coming from... | 10 April 1998, 18:43:30 UTC |
b5bd8c3 | Marc G. Fournier | 10 April 1998, 02:59:38 UTC | make --with-libs == --with-libraries | 10 April 1998, 02:59:38 UTC |
d8b0781 | Bruce Momjian | 10 April 1998, 02:48:08 UTC | Clean up HISTORY file so I can generate cleaner HTML. | 10 April 1998, 02:48:08 UTC |
7e12122 | Bruce Momjian | 09 April 1998, 04:42:56 UTC | Oops reverse patch. no need for it. | 09 April 1998, 04:42:56 UTC |
fa785ba | Bruce Momjian | 09 April 1998, 04:24:52 UTC | Allow -lib-dir to find libreadline.a | 09 April 1998, 04:24:52 UTC |
b91d94e | Thomas G. Lockhart | 08 April 1998, 06:42:17 UTC | Still mostly empty but add info on PAGER env variable and general paging behavior from Brett McCormick. | 08 April 1998, 06:42:17 UTC |
43cfa1a | Thomas G. Lockhart | 08 April 1998, 06:40:09 UTC | Fix incorrect second argument type for dpow() declaration. | 08 April 1998, 06:40:09 UTC |
242b347 | Thomas G. Lockhart | 08 April 1998, 06:39:01 UTC | Prepare the EXTRACT() clause for supporting TIMEZONE_HOUR and TIMEZONE_MINUTE but don't introduce until v6.4. Fix SET TIMEZONE LOCAL to pass null pointer rather than older "default" string. Fix handling of NULL pointer returns from FOREIGN KEY clauses which are currently ignored. Allow START as a table/column name. | 08 April 1998, 06:39:01 UTC |
31b9e3f | Thomas G. Lockhart | 08 April 1998, 06:35:02 UTC | Temporarily back out fixes for unary minus parsing. Will re-introduce for v6.4 but requires fixes for automatic type conversion beforehand. | 08 April 1998, 06:35:02 UTC |
45a0b47 | Bruce Momjian | 08 April 1998, 02:32:52 UTC | Remove name.* files. | 08 April 1998, 02:32:52 UTC |
4a7b30d | Marc G. Fournier | 08 April 1998, 02:06:37 UTC | From: Bruce Stephens <bruce@cenderis.demon.co.uk> fix for the tk problem... | 08 April 1998, 02:06:37 UTC |
bf7b721 | Bruce Momjian | 07 April 1998, 22:36:38 UTC | Re-add pg_dump fix. | 07 April 1998, 22:36:38 UTC |
e83621a | Bruce Momjian | 07 April 1998, 22:00:37 UTC | Reverse out pg_dump changes. | 07 April 1998, 22:00:37 UTC |
3da39b3 | Bruce Momjian | 07 April 1998, 21:26:52 UTC | Update configure. | 07 April 1998, 21:26:52 UTC |
8e81164 | Bruce Momjian | 07 April 1998, 21:01:28 UTC | Update for 6.3.2 | 07 April 1998, 21:01:28 UTC |
db21523 | Bruce Momjian | 07 April 1998, 18:14:38 UTC | Back out char2-char16 removal. Add later. | 07 April 1998, 18:14:38 UTC |
6a3c751 | Bruce Momjian | 07 April 1998, 16:41:11 UTC | Fix for ACL's from Thomas A. Szybist. | 07 April 1998, 16:41:11 UTC |
1125bbf | Bruce Momjian | 06 April 1998, 17:52:35 UTC | Assert fix | 06 April 1998, 17:52:35 UTC |
2ffd727 | Bruce Momjian | 06 April 1998, 17:27:54 UTC | ASSERT fixes. | 06 April 1998, 17:27:54 UTC |
d8077ab | Bruce Momjian | 06 April 1998, 17:02:13 UTC | distclean cleanup | 06 April 1998, 17:02:13 UTC |
471dbbc | Bruce Momjian | 06 April 1998, 16:53:15 UTC | DESTDIR removed, again. | 06 April 1998, 16:53:15 UTC |
0bf8141 | Thomas G. Lockhart | 06 April 1998, 15:33:53 UTC | Older html conversion of original docs to html superceded by the new sgml/docbook versions. | 06 April 1998, 15:33:53 UTC |
cf1f24f | Bruce Momjian | 06 April 1998, 04:57:32 UTC | destdir cleanup. | 06 April 1998, 04:57:32 UTC |
c61846e | Bruce Momjian | 06 April 1998, 03:23:01 UTC | Makefile cleanup./ | 06 April 1998, 03:23:01 UTC |
041d2e1 | Bruce Momjian | 06 April 1998, 03:10:32 UTC | confiure cleanup | 06 April 1998, 03:10:32 UTC |
6451462 | Bruce Momjian | 06 April 1998, 02:38:26 UTC | Cleanup of compiler warnings. | 06 April 1998, 02:38:26 UTC |
6d708c6 | Bruce Momjian | 06 April 1998, 02:10:49 UTC | Cleanup initdb | 06 April 1998, 02:10:49 UTC |
bc40727 | Bruce Momjian | 06 April 1998, 02:03:08 UTC | cleanup and possible alpha-linux fix. | 06 April 1998, 02:03:08 UTC |
066ee9a | Bruce Momjian | 06 April 1998, 01:36:41 UTC | Make DESTDIR consistent, and verious Linux cleanups. | 06 April 1998, 01:36:41 UTC |
5523beb | Bruce Momjian | 06 April 1998, 01:16:55 UTC | Re-introduce $DISTDIR. | 06 April 1998, 01:16:55 UTC |
47364f3 | Bruce Momjian | 06 April 1998, 01:05:54 UTC | Move initdb.sh to initdb | 06 April 1998, 01:05:54 UTC |
1e801a8 | Bruce Momjian | 06 April 1998, 00:32:26 UTC | Hi, Attached you'll find a (big) patch that fixes make dep and make depend in all Makefiles where I found it to be appropriate. It also removes the dependency in Makefile.global for NAMEDATALEN and OIDNAMELEN by making backend/catalog/genbki.sh and bin/initdb/initdb.sh a little smarter. This no longer requires initdb.sh that is turned into initdb with a sed script when installing Postgres, hence initdb.sh should be renamed to initdb (after the patch has been applied :-) ) This patch is against the 6.3 sources, as it took a while to complete. Please review and apply, Cheers, Jeroen van Vianen | 06 April 1998, 00:32:26 UTC |
2dfee93 | Bruce Momjian | 05 April 1998, 22:02:56 UTC | Remove DISTDIR. | 05 April 1998, 22:02:56 UTC |
fdb37f0 | Bruce Momjian | 05 April 1998, 21:29:49 UTC | this patch solve 2 problemes : probleme number 1 : - configure can find the library readline , but don't find the header file . so in this case we don't use lib readline . probleme number 2 : - when you have postgres 6.2.1 and readline installed with the same prefix( and generally all your software ) . you can compile the version 6.3 . I use this prefix , when configure ask me for "Additional directories to search for include files" . ( because there a conflict in the header when you compile psql.c ) In this case, you must permut the sequence of directive -I . Erwan MAS | 05 April 1998, 21:29:49 UTC |
34fec16 | Bruce Momjian | 05 April 1998, 21:18:03 UTC | configure cleanup. | 05 April 1998, 21:18:03 UTC |
4b6fcc4 | Bruce Momjian | 05 April 1998, 21:04:50 UTC | Remove GetDatabaseName/Path and use globals. Make consts later. | 05 April 1998, 21:04:50 UTC |
9e45687 | Bruce Momjian | 05 April 1998, 20:54:38 UTC | confiugre.in cleanup. | 05 April 1998, 20:54:38 UTC |
05102c7 | Bruce Momjian | 05 April 1998, 20:28:23 UTC | Here are 3 patches (all relative to the src directory) to help with the configuration of v6.3.1. I have replaced the queries for include/lib directories with --with configuration options. I have also included a list of potential tcl/tk include directories directly in the CPPFLAGS variable. As new versions are needed, these should be added to the list in reverse numerical order (libraries are in a separate list near the end). This greatly simplifies the later checks if --with-tcl is set. I hope this solution works for everyone. I also added a check to disable the perl support if postgres was not already installed (as per the instructions in the directory). By the way, why must there be an installed pgsql to compile perl support? This seems odd, at best. Finally, I changed the Makefile in the libpgtcl interface to place the shared libraries at the end of the list of files, not at the beginning. With NetBSD at least, libraries are linked in order, so the original sequence does not work. Brook Milligan | 05 April 1998, 20:28:23 UTC |
7a9385e | Thomas G. Lockhart | 05 April 1998, 17:10:41 UTC | Information completely translated to the SGML/DocBook source files pgtcl.sgml, spi.sgml, trigger.sgml. Online docs in html and postscript are the current versions. | 05 April 1998, 17:10:41 UTC |
e98562a | Thomas G. Lockhart | 05 April 1998, 17:07:32 UTC | Include complete Makefile.global if available, rather than just Makefile.custom. | 05 April 1998, 17:07:32 UTC |
03a7cd1 | Bruce Momjian | 05 April 1998, 05:52:10 UTC | Fix for memory leak. | 05 April 1998, 05:52:10 UTC |
39740d7 | Thomas G. Lockhart | 04 April 1998, 16:35:22 UTC | Clean up formatting. Add more URL links for GiST information. | 04 April 1998, 16:35:22 UTC |
e47e0e6 | Thomas G. Lockhart | 04 April 1998, 16:34:23 UTC | Include example of table loading using the COPY command. | 04 April 1998, 16:34:23 UTC |
c452ddc | Thomas G. Lockhart | 04 April 1998, 16:32:01 UTC | Convert body of chapter to SGML. Was embedded text from original doc. | 04 April 1998, 16:32:01 UTC |
e01d442 | Thomas G. Lockhart | 04 April 1998, 16:30:31 UTC | Small corrections from Phil Thompson, the original author. | 04 April 1998, 16:30:31 UTC |
7a07012 | Thomas G. Lockhart | 04 April 1998, 16:26:05 UTC | Include the stub docs for the rules system. Omission in original versions. | 04 April 1998, 16:26:05 UTC |
6755026 | Bruce Momjian | 03 April 1998, 20:21:51 UTC | A couple of weeks ago I submitted a patch to fix configure --with-tcl. However somebody else also applied a patch to the same part of configure to fix a different problem. So part of my patch was not applied or got reversed or ... whatever. The attached patch will restore configure --with-tcl to working order and should remove a lot of the messages complaining about tcl not working. Alvin | 03 April 1998, 20:21:51 UTC |
bb80f8a | Vadim B. Mikheev | 02 April 1998, 07:27:15 UTC | Fix merging pathes of pruned rels ("indices are unused" problem). | 02 April 1998, 07:27:15 UTC |
91964bd | Marc G. Fournier | 01 April 1998, 18:47:47 UTC | resync configure | 01 April 1998, 18:47:47 UTC |
896a42a | Marc G. Fournier | 01 April 1998, 15:35:33 UTC | From: Maurice Gittens <mgittens@david.gits.nl> After applying the following patch there remain two probable buffer overruns detected by Electric Fence during the regression test. I'll try find out what causes the remain two ones. This patch also corrects a typo in smgr.c. | 01 April 1998, 15:35:33 UTC |
0a0bd3d | Marc G. Fournier | 01 April 1998, 03:13:37 UTC | remove the call to port-protos.h ... | 01 April 1998, 03:13:37 UTC |
8dc48ba | Bruce Momjian | 31 March 1998, 23:31:10 UTC | Small HAVING cleanup. | 31 March 1998, 23:31:10 UTC |
9fbdda0 | Bruce Momjian | 31 March 1998, 15:53:51 UTC | Fix macro read violation for Maurice. | 31 March 1998, 15:53:51 UTC |
d7050cb | Bruce Momjian | 31 March 1998, 04:44:35 UTC | Merge rename name page into alter table. Fix UNION with DISTINCT or ORDER BY bug. | 31 March 1998, 04:44:35 UTC |
62943bb | Marc G. Fournier | 31 March 1998, 03:00:20 UTC | Pointed out by: Doug Winterburn <dlw@seavme.xroads.com> 3) Add "#include "config.h" to src/interfaces/ecpg/preproc/pgc.l to correct "strings.h not found". config.h has the proper define to make this work and should probably be near the top of pgc.l before the first include. | 31 March 1998, 03:00:20 UTC |
92c6bf9 | Marc G. Fournier | 31 March 1998, 02:59:07 UTC | Pointed out by: Doug Winterburn <dlw@seavme.xroads.com> 2) Add "#define gettimeofday(a,b) gettimeofday(a) to src/include/config.h On the 88k SVR4, gettimeofday only has one argument. This is checked for in a few other packages by configure, so there should be some examples of the configure test out there. | 31 March 1998, 02:59:07 UTC |
01ecb2e | Bruce Momjian | 30 March 1998, 19:05:10 UTC | documentation for HAVING, clean up UNION comment. | 30 March 1998, 19:05:10 UTC |
ef0eecf | Bruce Momjian | 30 March 1998, 17:46:45 UTC | This simple patch to catalog/pg_type.c fixes a buffer overrun. It was detected by Electric Fence and triggered by statements like: SELECT * into table t from pg_database; The system would crash on a memmove call in DataFile() with arguments like this: memmove(0x0, 0x0, 0); Maurice Gittens | 30 March 1998, 17:46:45 UTC |
dbf34c5 | Bruce Momjian | 30 March 1998, 17:39:16 UTC | This problem had nothing to do with the upgrades I made. There was a 2000 character buffer allocated for results, and the files you refer to produce a 2765 byte column called formsource. This should not have worked with any version of libpgtcl. Nevertheless, the limit is an artificial one, since there is no need to use this intermediate buffer where it is being used and abused. Randy Kunkee <kunkee@pluto.ops.NeoSoft.com> | 30 March 1998, 17:39:16 UTC |
57b5966 | Bruce Momjian | 30 March 1998, 17:28:21 UTC | The following uuencoded, gzip'd file will ... 1. Remove the char2, char4, char8 and char16 types from postgresql 2. Change references of char16 to name in the regression tests. 3. Rename the char16.sql regression test to name.sql. 4. Modify the regression test scripts and outputs to match up. Might require new regression.{SYSTEM} files... Darren King | 30 March 1998, 17:28:21 UTC |
31c3610 | Bruce Momjian | 30 March 1998, 17:15:26 UTC | The buffer overrun while creating sequences turns out to be a read access overrun. For the sake of doing things properly here is a patch which fixes it. This patch is for the file backend/commands/sequence.c. Maurice Gittens | 30 March 1998, 17:15:26 UTC |
9a0dd4f | Bruce Momjian | 30 March 1998, 16:47:35 UTC | There's a patch attached to fix gcc 2.8.x warnings, except for the yyerror ones from bison. It also includes a few 'enhancements' to the C programming style (which are, of course, personal). The other patch removes the compilation of backend/lib/qsort.c, as qsort() is a standard function in stdlib.h and can be used any where else (and it is). It was only used in backend/optimizer/geqo/geqo_pool.c, backend/optimizer/path/predmig.c, and backend/storage/page/bufpage.c > > Some or all of these changes might not be appropriate for v6.3, since we > > are in beta testing and since they do not affect the current functionality. > > For those cases, how about submitting patches based on the final v6.3 > > release? There's more to come. Please review these patches. I ran the regression tests and they only failed where this was expected (random, geo, etc). Cheers, Jeroen | 30 March 1998, 16:47:35 UTC |
c579ce0 | Bruce Momjian | 30 March 1998, 16:36:43 UTC | I started adding the Having Clause and it works quite fine for sequential scans! (I think it will also work with hash, index, etc but I did not check it out! I made some High level changes which should work for all access methods, but maybe I'm wrong. Please let me know.) Now it is possible to make queries like: select s.sname, max(p.pid), min(p.pid) from part p, supplier s where s.sid=p.sid group by s.sname having max(pid)=6 and min(pid)=1 or avg(pid)=4; Having does not work yet for queries that contain a subselect statement in the Having clause, I'll try to fix this in the next days. If there are some bugs, please let me know, I'll start to read the mailinglists now! Now here is the patch against the original 6.3 version (no snapshot!!): Stefan | 30 March 1998, 16:36:43 UTC |
9c93fa2 | Marc G. Fournier | 29 March 1998, 21:52:54 UTC | Upgrade to v0.86 | 29 March 1998, 21:52:54 UTC |
748fab8 | Bruce Momjian | 28 March 1998, 02:24:49 UTC | Prevent pgindent from being run on odbc in the future. | 28 March 1998, 02:24:49 UTC |
f07c7bf | Bruce Momjian | 26 March 1998, 23:46:14 UTC | I have been troubled by a segmentation fault when reloading from a dumpall. This has been happening when a second \connect is encountered. The faulty code was in fe-connect.c, where the memory for the user password was freed, but the pointer itself was not set to NULL. Later, the memory was reused and the password appeared not to be empty, so that an attempt was made to reference it. Oliver Elphick | 26 March 1998, 23:46:14 UTC |
0d8a7dc | Bruce Momjian | 26 March 1998, 21:08:10 UTC | BETWEEN and LIKE patch from Thomas | 26 March 1998, 21:08:10 UTC |
3b40fd9 | Bruce Momjian | 26 March 1998, 21:01:47 UTC | Update manual | 26 March 1998, 21:01:47 UTC |
b411e26 | Bruce Momjian | 25 March 1998, 01:54:53 UTC | Mention rollback instead of abort. | 25 March 1998, 01:54:53 UTC |
4d1a60a | Bruce Momjian | 25 March 1998, 01:45:33 UTC | install cleanup | 25 March 1998, 01:45:33 UTC |
d6adef4 | Bruce Momjian | 23 March 1998, 17:54:47 UTC | FAQ_Irix update | 23 March 1998, 17:54:47 UTC |
f74f2d3 | Bruce Momjian | 23 March 1998, 16:14:50 UTC | update for 6.3.1 | 23 March 1998, 16:14:50 UTC |
817fc4b | Bruce Momjian | 23 March 1998, 15:09:43 UTC | Manual page fixes. | 23 March 1998, 15:09:43 UTC |