summaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAgeFilesLines
* The buffer overrun while creating sequences turns out to be a readBruce Momjian1998-03-301-1/+3
| | | | | | | | | 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
* There's a patch attached to fix gcc 2.8.x warnings, except for theBruce Momjian1998-03-3017-397/+86
| | | | | | | | | | | | | | | | | | | | | | | | 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
* I started adding the Having Clause and it works quite fine forBruce Momjian1998-03-309-16/+173
| | | | | | | | | | | | | | | | | | | | | | | | 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
* Upgrade to v0.86Marc G. Fournier1998-03-296-283/+307
|
* Prevent pgindent from being run on odbc in the future.Bruce Momjian1998-03-281-1/+1
|
* I have been troubled by a segmentation fault when reloading fromBruce Momjian1998-03-261-1/+2
| | | | | | | | | | | | 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
* BETWEEN and LIKE patch from ThomasBruce Momjian1998-03-261-1/+16
|
* Update manualBruce Momjian1998-03-262-6/+3
|
* Mention rollback instead of abort.Bruce Momjian1998-03-255-11/+11
|
* update for 6.3.1Bruce Momjian1998-03-232-3/+2
|
* Manual page fixes.Bruce Momjian1998-03-2310-41/+41
|
* autoconf again.Bruce Momjian1998-03-231-15/+11
|
* more tcl/tk fixesBruce Momjian1998-03-234-12/+7
|
* Another tcl/tk fix.Bruce Momjian1998-03-232-7/+5
|
* oops, forgot to run autoconf.Bruce Momjian1998-03-231-1/+1
|
* another tcl/tk patchBruce Momjian1998-03-231-1/+1
| | | | another tcl/tk patch
* fix for tcl/tk in configureBruce Momjian1998-03-232-119/+19
|
* Add NetBSD specific expected filesMarc G. Fournier1998-03-224-0/+1012
|
* Slightly updated regression output for FreeBSD 3.0-CURRENTMarc G. Fournier1998-03-221-100/+36
|
* Made some changes to clean up how initdb works...just more made a 'PGSQL_OPTS'Marc G. Fournier1998-03-221-21/+19
| | | | variable that can be set in one place to affect everything...
* Change 2>$1 to -o /dev/null instead...Marc G. Fournier1998-03-221-6/+3
| | | | From: Andreas Klemm <andreas@klemm.gtn.com>
* Moved sys/types.h to before netdb.hMarc G. Fournier1998-03-221-2/+2
| | | | From: Vince Vielhaber <vev@michvhf.com>
* Better identify tcl and tk.Bruce Momjian1998-03-212-8/+8
|
* This patch fixes a couple of minor bugs:Bruce Momjian1998-03-202-1/+6
| | | | | | | | | | | | | | 1) DatabaseMetaData.getPrimaryKeys() would fail saying that there is no table t. 2) PreparedStatement.getObject() was missing some break statements, which was causing updates not to work with JBuilder (supplied by Aaron Dunlop). jdbc fixes from Peter.
* Disable -lbsd on alpha.Bruce Momjian1998-03-202-4/+4
|
* Add missing file.Bruce Momjian1998-03-201-0/+4
|
* OK...here is a patch that will cause the magnetic disk storageBruce Momjian1998-03-201-4/+128
| | | | | | | | | | | manager to not try to split files in 2 gig chunks. It will just try to get another block. If applied, everything is just as before. But if LET_OS_MANAGE_FILESIZE is defined, the chaining disappears and the file just keeps on going, and going, and going, til the OS barfs. Darren King
* Sorry. I made above mistakes. "__svr4" should be "__svr4__" orBruce Momjian1998-03-201-2/+2
| | | | | | | "__SVR4" as you pointed out. There is another file that has the same mistakes. Included is a patche for include/c.h. t-ishii@sra.co.jp
* Fix spelling of "includingBruce Momjian1998-03-202-4/+4
| | | | Edward J. Huff
* HPUX build does not build shared lib versions of libpq and libpq++Bruce Momjian1998-03-202-2/+14
| | | | | | | | | | | | | | -------------------------------------------------------------------------- Test Case: ---------- -------------------------------------------------------------------------- Solution: --------- Add this to the libpq and libpq++ Makefiles to build shared libs: Mike Ferrara
* In libpq-fe.h: #if defined(sun) && defined(sparc) && !defined(__svr4)Bruce Momjian1998-03-201-2/+2
| | | | | | | | | | extern char *sys_errlist[]; #define strerror(A) (sys_errlist[(A)]) #endif /* sunos4 */ is picked up by Solaris when the above is intended only for SunOS. Fix Solaris. Albert Chin-A-Young
* The real trick is to add -Dalpha to the CFLAGS setting. The changesBruce Momjian1998-03-202-2/+9
| | | | | | | | | | | | | to main.c are only to add some extra includes to support some code that's suddenly being used. The #define ASSEMBLER is to prevent most of the code of sys/proc.h from being included, as it ends up conflicting with some of the postgresql definitions. This may or may not work on other versions of Digital Unix. Get alpha working. Yea. Dwayne Bailey
* > > I'm using text[] arrays. Some of my array elements have '"'Bruce Momjian1998-03-201-4/+14
| | | | | | | | > > characters in them. Dumping and reloading using pg_dumpall > > doesn't work with this and dumping the entire array and > > then trying to parse it is hopeless. Doug Gibson
* Here's my next patch to bring ecpg to version 1.1. It now correctlyBruce Momjian1998-03-2014-90/+270
| | | | | | handles all transaction commands and the exec sql include command. Michael Meskes
* Allow parsing expressions with ") -" (scan.l, scan.c only).Thomas G. Lockhart1998-03-186-4848/+5035
| | | | | | | | | Make "TABLE" optional in "LOCK TABLE" command and "... INTO TABLE..." clause. Explicitly parse CREATE SEQUENCE options to allow a negative integer as an argument; this is an artifact of unary minus handling in scan.l. Add "PASSWORD" as an allowed column identifier. These fixes will require a "make clean install" but not a dump/reload.
* Add checks for UNION target fields, and add optional TABLE to LOCKBruce Momjian1998-03-184-10/+25
| | | | and SELECT manual pages and psql help.
* SunOS .similar cleanup.Bruce Momjian1998-03-161-4/+1
|
* Add SunOS entries.Bruce Momjian1998-03-161-0/+4
|
* Prevent \do from wrapping.Bruce Momjian1998-03-161-4/+4
|
* Make pg_user /xpg_user change complete.Bruce Momjian1998-03-161-1/+8
|
* Remove duplicatesBruce Momjian1998-03-166-417/+0
|
* Fix for Datasize = 0 error, from Vadim.Bruce Momjian1998-03-161-2/+2
|
* Fix for pg_dump of large objects, from alvin@camberlo.demon.co.uk.Bruce Momjian1998-03-161-3/+3
|
* subselect notes from Vadim.Bruce Momjian1998-03-161-0/+156
|
* From: Jeroen van Vianen <jeroenv@design.nl>Marc G. Fournier1998-03-152-4/+9
| | | | | tools.patch patches tools/find_static (use indices to increase performance) and tools/ccsym (no hardcoded paths).
* From: hankin <hankin@consultco.com>Marc G. Fournier1998-03-151-4/+8
| | | | | | | | | | a while back I posted a patch for pg_ident, the patch worked but I didn't diagnose the problem properly. on my compiler(gcc2.7.2) this compiles with no errors... char buf[1000]; if(buf != '\0') { ...but it doesn't compare '\0' with the first char of buf.
* Reply-To: Jordi MacDonald <jordi@spartanmedia.com>Marc G. Fournier1998-03-152-3/+3
| | | | | | | | | | | | | | | | | There is an error in the configure script when using --with-pgport= that will cause the compiled version of PostgreSQL to no longer allow connections to the new port and to treat shared memory improperly. What happens is that if the port is changed, the configure script defines DEF_PGPORT as "", which atoi() will return as 0, which makes the IPC_KEY value 0. This then causes semaphores to be allocated, but never released. Postgres eventually returns from semget() with "no space left on device". The source of this error could easily be overlooked in version 6.3 since it is possible to connect via UNIX domain sockets, and having DEF_PGPORT defined as "0" would not be noticed until TCP was used.
* From: Randy Kunkee <kunkee@pluto.ops.NeoSoft.com>Marc G. Fournier1998-03-151-1/+3
| | | | | | The following patch is to src/interfaces/libpq of postgresql-6.3. The purpose of the patch is to make the initialization of const char *pgresStatus[] match the ExecStatusType enum.
* From: t-ishii@sra.co.jpMarc G. Fournier1998-03-151-0/+8
| | | | | | | 6.3 postmaster is supposed to work with pre 6.3 protocol. This is true for little endian architecture servers. But for big endian machines such as Sparc the backward compatibility function do not work. Attached are patches to fix the problem.
* From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>Marc G. Fournier1998-03-151-2/+2
| | | | | | | | For substr() and substring() on the text data type, the relevant code is in varlena.c. You are right, there is a problem. I have a patch which I will apply to the source tree soon. The copy enclosed below probably does not preserve tabs correctly so cannot be applied directly; the relevant change is simply changing the ">=" to ">"...
View Lorry Controller Status