summaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAgeFilesLines
* Remove fixed-size literal buffer from scan.l, and repairTom Lane1999-10-182-62/+73
| | | | | | | | boundary-condition bug in myinput() which caused flex scanner to fail on tokens larger than a bufferload. Turns out flex doesn't want null- terminated input ... and if it gives you a 1-character buffer, you'd better supply a character, not a null, lest you be thought to be reporting end of input.
* Except_Intersect_Rewrite() forgot to move LIMIT info to newTom Lane1999-10-171-1/+8
| | | | topmost SELECT node after rearranging query tree.
* Change fd.c so that temp files are closed and deleted atTom Lane1999-10-171-5/+9
| | | | | | | proc_exit time. I discovered that if the frontend closes the connection when you're inside a transaction block, there is nothing ensuring that temp files go away ... I wonder whether proc_exit ought to try to do an explicit transaction abort?
* Remove now-dead sort modules.Tom Lane1999-10-175-1479/+0
|
* Final stage of psort reconstruction work: replace psort.c withTom Lane1999-10-1710-1018/+1747
| | | | | | | a generalized module 'tuplesort.c' that can sort either HeapTuples or IndexTuples, and is not tied to execution of a Sort node. Clean up memory leakages in sorting, and replace nbtsort.c's private implementation of mergesorting with calls to tuplesort.c.
* Actually, nodeMergejoin shouldn't include psort.h at all...Tom Lane1999-10-171-2/+1
|
* nodeMergejoin was depending on an inclusion from psort.h...Tom Lane1999-10-161-1/+2
|
* Second phase of psort reconstruction project: add bookkeeping logic toTom Lane1999-10-167-452/+1293
| | | | | | recycle storage within sort temp file on a block-by-block basis. This reduces peak disk usage to essentially just the volume of data being sorted, whereas it had been about 4x the data volume before.
* Check RELSEG_SIZE when postmaster starting up.Tatsuo Ishii1999-10-161-0/+10
| | | | | this is neccesary to make sure that the backend and the database uses same RELSEG_SIZE.
* *** empty log message ***Michael Meskes1999-10-156-55/+99
|
* Fix typo in descriptions.Bruce Momjian1999-10-151-2/+2
|
* Clean up type descriptions.Bruce Momjian1999-10-151-3/+3
|
* This patch implements ORACLE's COMMENT SQL command.Bruce Momjian1999-10-1512-21/+287
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | >From the ORACLE 7 SQL Language Reference Manual: ----------------------------------------------------- COMMENT Purpose: To add a comment about a table, view, snapshot, or column into the data dictionary. Prerequisites: The table, view, or snapshot must be in your own schema or you must have COMMENT ANY TABLE system privilege. Syntax: COMMENT ON [ TABLE table ] | [ COLUMN table.column] IS 'text' You can effectively drop a comment from the database by setting it to the empty string ''. ----------------------------------------------------- Example: COMMENT ON TABLE workorders IS 'Maintains base records for workorder information'; COMMENT ON COLUMN workorders.hours IS 'Number of hours the engineer worked on the task'; to drop a comment: COMMENT ON COLUMN workorders.hours IS ''; The current patch will simply perform the insert into pg_description, as per the TODO. And, of course, when the table is dropped, any comments relating to it or any of its attributes are also dropped. I haven't looked at the ODBC source yet, but I do know from an ODBC client standpoint that the standard does support the notion of table and column comments. Hopefully the ODBC driver is already fetching these values from pg_description, but if not, it should be trivial. Hope this makes the grade, Mike Mascari (mascarim@yahoo.com)
* Update psql \? for \w.Bruce Momjian1999-10-141-2/+2
|
* Correctly return -1 on error to CmdTuples()Bruce Momjian1999-10-131-2/+2
| | | | Vince.
* Split 'BufFile' routines out of fd.c into a new module, buffile.c. ExtendTom Lane1999-10-1312-318/+707
| | | | | | | | BufFile so that it handles multi-segment temporary files transparently. This allows sorts and hashes to work with data exceeding 2Gig (or whatever the local limit on file size is). Change psort.c to use relative seeks instead of absolute seeks for backwards scanning, so that it won't fail when the data volume exceeds 2Gig.
* Hi,Bruce Momjian1999-10-135-14/+8
| | | | | | | | | | | | I have changed a bit the makefiles for the win32 port - the *.def files (created when building shared libraries) are now clean from Makefile.shlib. I have also removed "-g" from CFLAGS in the "cygwin32" template - it can be enabled when running configure. Dan
* Update jdbc for release version #>Bruce Momjian1999-10-131-0/+2
|
* BLOBs containing NUL characters (ASCII 0) can be written to theBruce Momjian1999-10-131-3/+3
| | | | | | | | | | | | | | | | | | | | | database, but they get truncated at the first NUL by lo_read when they are read back. The reason for this is that lo_read in Pg.xs is using the default: OUTPUT: RETVAL buf which uses C's strlen() to work out the length of the scalar. The code ought to read something more like: OUTPUT: RETVAL buf sv_setpvn((SV*)ST(2), buf, RETVAL); I am not sure if this needs to be done on both lo_read methods in this file, but I changed both and have not since had any problems with truncated BLOBs. Douglas Thomson <dougt@mugc.cc.monash.edu.au>
* I have created a small patch that makes possible to compile pgsql on newerBruce Momjian1999-10-122-3/+8
| | | | | | | | | | | Cygwin snapshots (tested on 990115 which is recommended to use - it fixes some errors in B20.1) And I have another patch for including <sys/ipc.h> before <sys/sem.h> in backend/storage/lmgr/proc.c - it is required due the design of cygipc headers Dan
* Remove pgeasy Makefile on distclean.Bruce Momjian1999-10-121-1/+2
|
* autoconfBruce Momjian1999-10-122-2/+0
|
* autoconfBruce Momjian1999-10-122-0/+2
|
* Update pgeasy for missing files.Bruce Momjian1999-10-123-0/+380
|
* Add blcksz to struct ControlFileData to check BLCKSZ is sameTatsuo Ishii1999-10-121-0/+5
| | | | as BLCKSZ which the backend was compiled in.
* Update pgeasy.Bruce Momjian1999-10-119-396/+18
|
* cleanup of pgeasy.Bruce Momjian1999-10-111-35/+1
|
* Update again.Bruce Momjian1999-10-111-2/+2
|
* pgeasy update.Bruce Momjian1999-10-1111-3/+3
|
* Update pgeasy.Bruce Momjian1999-10-111-2/+2
|
* autoconfBruce Momjian1999-10-111-0/+2
|
* Add pginterface into main tree, called pgeasy.Bruce Momjian1999-10-1115-5/+888
|
* The 1st step to implement new type of scan,TidScan.Hiroshi Inoue1999-10-116-10/+238
| | | | | Now WHERE restriction on ctid is allowed though it is sequentially scanned.
* Improve pg_dump template1 error reports.Bruce Momjian1999-10-101-4/+9
|
* Re-add mention of FAQ's for shared memory/ipc errors.Bruce Momjian1999-10-101-6/+9
|
* Improve pg_dump template1 error message.Bruce Momjian1999-10-101-4/+6
|
* Allow \r as whitespace.Bruce Momjian1999-10-091-2/+2
|
* Move __alpha to port/alpha.h.Bruce Momjian1999-10-092-5/+6
|
* Define __alpha__ for __alpha.Bruce Momjian1999-10-082-2/+8
|
* First real FOREIGN KEY constraint trigger functionality.Jan Wieck1999-10-081-12/+942
| | | | | | | | | Implemented now: FOREIGN KEY ... REFERENCES ... MATCH FULL FOREIGN KEY ... MATCH FULL ... ON DELETE CASCADE Jan
* *** empty log message ***Michael Meskes1999-10-089-441/+293
|
* Update display of debug levels.Bruce Momjian1999-10-082-5/+5
|
* clean up debug flags.Bruce Momjian1999-10-081-11/+3
|
* Comment cleanup.Bruce Momjian1999-10-081-3/+3
|
* Fix for "--" comment and no trailing newline, as seen in Perl.Bruce Momjian1999-10-082-4/+4
|
* Cleanup -is flag to -l for SSL. Another PERL variable name fix. CleanBruce Momjian1999-10-085-35/+31
| | | | | up debugging options for postmaster and postgres programs. postmaster -d is no longer optional. Documentation updates.
* Remove a no-longer-needed kluge for degenerate aggregate cases,Tom Lane1999-10-082-23/+12
| | | | and update some comments.
* More startup/shutdown log messages.Vadim B. Mikheev1999-10-081-10/+43
|
* Use $(PERL) variable for perl compile. Now in Makefile.global.Bruce Momjian1999-10-081-2/+2
|
* Somehow missed this call to addRangeTableEntry() ...Tom Lane1999-10-071-2/+2
|
View Lorry Controller Status