summaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAgeFilesLines
...
* Make DESTDIR consistent, and verious Linux cleanups.Bruce Momjian1998-04-061-14/+14
|
* Hi,Bruce Momjian1998-04-0647-311/+169
| | | | | | | | | | | | | | | | | | | | | | 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
* Remove GetDatabaseName/Path and use globals. Make consts later.Bruce Momjian1998-04-055-37/+12
|
* Fix for memory leak.Bruce Momjian1998-04-052-8/+8
|
* Fix merging pathes of pruned rels ("indices are unused" problem).Vadim B. Mikheev1998-04-021-25/+11
|
* From: Maurice Gittens <mgittens@david.gits.nl>Marc G. Fournier1998-04-015-14/+23
| | | | | | | | | 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.
* remove the call to port-protos.h ...Marc G. Fournier1998-04-011-5/+1
|
* Small HAVING cleanup.Bruce Momjian1998-03-314-11/+16
|
* Merge rename name page into alter table. Fix UNION with DISTINCTBruce Momjian1998-03-312-16/+31
| | | | or ORDER BY bug.
* documentation for HAVING, clean up UNION comment.Bruce Momjian1998-03-301-5/+21
|
* This simple patch to catalog/pg_type.c fixes a buffer overrun. ItBruce Momjian1998-03-301-2/+4
| | | | | | | | | | | | | 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
* The following uuencoded, gzip'd file will ...Bruce Momjian1998-03-3018-700/+107
| | | | | | | | | | | 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
* 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-3015-394/+79
| | | | | | | | | | | | | | | | | | | | | | | | 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
* BETWEEN and LIKE patch from ThomasBruce Momjian1998-03-261-1/+16
|
* 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
* The real trick is to add -Dalpha to the CFLAGS setting. The changesBruce Momjian1998-03-201-1/+8
| | | | | | | | | | | | | 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
* 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-181-2/+17
| | | | and SELECT manual pages and psql help.
* Fix for Datasize = 0 error, from Vadim.Bruce Momjian1998-03-161-2/+2
|
* subselect notes from Vadim.Bruce Momjian1998-03-161-0/+156
|
* 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.
* 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 ">"...
* From: t-ishii@sra.co.jpMarc G. Fournier1998-03-1512-117/+819
| | | | | | | | | | | | | | | Included are patches intended for allowing PostgreSQL to handle multi-byte charachter sets such as EUC(Extende Unix Code), Unicode and Mule internal code. With the MB patch you can use multi-byte character sets in regexp and LIKE. The encoding system chosen is determined at the compile time. To enable the MB extension, you need to define a variable "MB" in Makefile.global or in Makefile.custom. For further information please take a look at README.mb under doc directory. (Note that unlike "jp patch" I do not use modified GNU regexp any more. I changed Henry Spencer's regexp coming with PostgreSQL.)
* Remove postgres95.Bruce Momjian1998-03-141-1/+1
|
* Get the ultrix4 ports back in sync...Marc G. Fournier1998-03-104-79/+2
|
* Repair "LIKE" behavior with two adjacent wildcard characters ("_").Thomas G. Lockhart1998-03-071-9/+10
| | | | Was ignoring second wildcard.
* Add one-line fix to allow redefining built-in functions.Thomas G. Lockhart1998-03-071-1/+2
| | | | Bug introduced in mid-January.
* pg_user cleanup.Bruce Momjian1998-03-062-15/+16
|
* Last minute clean up for SunOS...Marc G. Fournier1998-03-022-5/+6
| | | | From: t-ishii@sra.co.jp
* Fix money type USE_LOCALE support at least for default "C" locale.Thomas G. Lockhart1998-03-021-26/+53
| | | | Still has questionable code for some locale-specific strings.
* From: "Billy G. Allie" <Bill.Allie@mug.org>Marc G. Fournier1998-03-011-3/+1
| | | | | The following patch will change the meaning of the isinf function in the HAVE_FPCLASS section from "not finite" to "is infinity".
* From: "Billy G. Allie" <Bill.Allie@mug.org>Marc G. Fournier1998-03-012-19/+19
| | | | | | | | | | | The following patches will allow postgreSQL 6.3 to compile and run on a UNIXWARE 2.1.2 system with the native C compiler with the following library change: The alloca function must be copied from the libucb.a archive and added to the libgen.a archive. Also, the GNU flex program is needed to successfully build postgreSQL.
* Fix scan adjusting for marked index tuples.Vadim B. Mikheev1998-02-281-1/+5
|
* From: Darren King <darrenk@insightdist.com>Marc G. Fournier1998-02-271-3/+3
| | | | | | | | Two incorrect printf formats in parser/parse_type.c. Prolly done by me a long time ago when I cleaned up int's and Oid's... Format flag is really just %u, not %ud. Harmless, but results in "type id lookup of 25d failed" instead of only "...25 failed"
* ExecReScan for MergeJoin.Vadim B. Mikheev1998-02-272-88/+75
| | | | | Marked inner tuple now is copied into mergestate->mj_MarkedTupleSlot - no more tricks arround ttc_shouldfree.
* In '(a,b,...) Op [ANY|ALL] (SubSelect)' Op is restricted toVadim B. Mikheev1998-02-271-2/+6
| | | | '=' and '<>'.
* Check SELECT permissions in subqueries.Vadim B. Mikheev1998-02-272-12/+15
|
* From: Darren King <darrenk@insightdist.com>Marc G. Fournier1998-02-272-218/+217
| | | | | | | | | | | | This patch will... 1. Remove the "-Wall" option from the ecpg/lib and ecpg/preproc Makefile. 2. Remove the addition of $(SRCDIR)/include and-or $(SRCDIR)/backend from ecpg/lib, ecpg/preproc, libpq and utils Makefiles. Already in CFLAGS... 3. Set MK_NO_LORDER and RANLIB in Makefile.aix to avoid a couple of extra steps taken care of by the 'ld' command anyways.
* execScan.c: in the end of scan projInfo->pi_slot must beVadim B. Mikheev1998-02-262-28/+41
| | | | | | | | return, not a slot returned from access method (they have different TupleDesc and MergeJoin node was broken). nodeIndexscan.c: index_markpos()/index_restrpos() call index-specific mark/restr funcs and are in use now (instead of IndexScanMarkPosition()/ExecIndexRestrPos()).
* index_markpos()/index_restrpos are used now.Vadim B. Mikheev1998-02-261-7/+1
|
* pgindent run before 6.3 release, with Thomas' requested changes.Bruce Momjian1998-02-26230-5111/+5532
|
* Fix 6.X vacuum bug in shrinking code.Vadim B. Mikheev1998-02-251-15/+11
|
* From: Jan Wieck <jwieck@debis.com>Marc G. Fournier1998-02-2516-120/+120
| | | | | | | | | | seems that my last post didn't make it through. That's good since the diff itself didn't covered the renaming of pg_user.h to pg_shadow.h and it's new content. Here it's again. The complete regression test passwd with only some float diffs. createuser and destroyuser work. pg_shadow cannot be read by ordinary user.
* pgindent changes for Thomas proc/lock cleanupBruce Momjian1998-02-251-3/+3
|
* Fix for locking problems an dpriority.Bruce Momjian1998-02-241-4/+5
|
* From: "Denis V. Dmitrienko" <denis@null.net>Marc G. Fournier1998-02-246-7/+394
| | | | | | | | | | | What it does: It solves stupid problem with cyrillic charsets IP-based on-fly recoding. take a look at /data/charset.conf for details. You can use any tables for any charset. Tables are from Russian Apache project. Tables in this patch contains also Ukrainian characters. Then run ./configure --enable-recode