summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
1999-10-15Clean up type descriptions.Bruce Momjian
1999-10-15This patch implements ORACLE's COMMENT SQL command.Bruce Momjian
>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)
1999-10-14Update psql \? for \w.Bruce Momjian
1999-10-13Correctly return -1 on error to CmdTuples()Bruce Momjian
Vince.
1999-10-13Split 'BufFile' routines out of fd.c into a new module, buffile.c. ExtendTom Lane
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.
1999-10-13Hi,Bruce Momjian
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
1999-10-13Update jdbc for release version #>Bruce Momjian
1999-10-13BLOBs containing NUL characters (ASCII 0) can be written to theBruce Momjian
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>
1999-10-12I have created a small patch that makes possible to compile pgsql on newerBruce Momjian
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
1999-10-12Remove pgeasy Makefile on distclean.Bruce Momjian
1999-10-12autoconfBruce Momjian
1999-10-12autoconfBruce Momjian
1999-10-12Update pgeasy for missing files.Bruce Momjian
1999-10-12Add blcksz to struct ControlFileData to check BLCKSZ is sameTatsuo Ishii
as BLCKSZ which the backend was compiled in.
1999-10-11Update pgeasy.Bruce Momjian
1999-10-11cleanup of pgeasy.Bruce Momjian
1999-10-11Update again.Bruce Momjian
1999-10-11pgeasy update.Bruce Momjian
1999-10-11Update pgeasy.Bruce Momjian
1999-10-11autoconfBruce Momjian
1999-10-11Add pginterface into main tree, called pgeasy.Bruce Momjian
1999-10-11The 1st step to implement new type of scan,TidScan.Hiroshi Inoue
Now WHERE restriction on ctid is allowed though it is sequentially scanned.
1999-10-10Improve pg_dump template1 error reports.Bruce Momjian
1999-10-10Re-add mention of FAQ's for shared memory/ipc errors.Bruce Momjian
1999-10-10Improve pg_dump template1 error message.Bruce Momjian
1999-10-09Allow \r as whitespace.Bruce Momjian
1999-10-09Move __alpha to port/alpha.h.Bruce Momjian
1999-10-08Define __alpha__ for __alpha.Bruce Momjian
1999-10-08First real FOREIGN KEY constraint trigger functionality.Jan Wieck
Implemented now: FOREIGN KEY ... REFERENCES ... MATCH FULL FOREIGN KEY ... MATCH FULL ... ON DELETE CASCADE Jan
1999-10-08*** empty log message ***Michael Meskes
1999-10-08Update display of debug levels.Bruce Momjian
1999-10-08clean up debug flags.Bruce Momjian
1999-10-08Comment cleanup.Bruce Momjian
1999-10-08Fix for "--" comment and no trailing newline, as seen in Perl.Bruce Momjian
1999-10-08Cleanup -is flag to -l for SSL. Another PERL variable name fix. CleanBruce Momjian
up debugging options for postmaster and postgres programs. postmaster -d is no longer optional. Documentation updates.
1999-10-08Remove a no-longer-needed kluge for degenerate aggregate cases,Tom Lane
and update some comments.
1999-10-08More startup/shutdown log messages.Vadim B. Mikheev
1999-10-08Use $(PERL) variable for perl compile. Now in Makefile.global.Bruce Momjian
1999-10-07Somehow missed this call to addRangeTableEntry() ...Tom Lane
1999-10-07Fix planner and rewriter to follow SQL semantics for tables that areTom Lane
mentioned in FROM but not elsewhere in the query: such tables should be joined over anyway. Aside from being more standards-compliant, this allows removal of some very ugly hacks for COUNT(*) processing. Also, allow HAVING clause without aggregate functions, since SQL does. Clean up CREATE RULE statement-list syntax the same way Bruce just fixed the main stmtmulti production. CAUTION: addition of a field to RangeTblEntry nodes breaks stored rules; you will have to initdb if you have any rules.
1999-10-06Small cleanup.Vadim B. Mikheev
1999-10-06XLOG (also known as WAL -:)) Bootstrap/Startup/Shutdown.Vadim B. Mikheev
First step in cleaning up backend initialization code. Fix for FATAL: now FATAL is ERROR + exit.
1999-10-06More more liszt language code, so remove it from pg_language.Bruce Momjian
1999-10-06Improve the treatment of partial(incomplete) blocks of relation files.Hiroshi Inoue
This may solve a TODO item * Recover or force failure when disk space is exhausted
1999-10-06Don't set BootstrapProcessingMode in AddNewRelationTuple() beforeVadim B. Mikheev
heap_insert() any more. No reasons to do it, and old comments said about this.
1999-10-06CmdTuples() returns an int showing the number of affected tuples after anBruce Momjian
insert, update or delete. It will return -1 on error, although I've yet to an error situation to prove that out! Vince
1999-10-05Allow comment-only lines, and ;;; lines too.Bruce Momjian
1999-10-04As we now use lipq++.H which wasn't around when I first posted theBruce Momjian
2 line GetIsNull diffs, we now need this too: Patrick Welche
1999-10-04Less noisy rule display...Tom Lane
1999-10-04Make the rule deparser a little less quote-happy, so thatTom Lane
display of default expressions isn't quite so ugly.
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-17 10:12:39 +0000