aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* I'm in TODO mood today ...Bruce Momjian1999-12-12
| | | | | | | | | | | | | | | | | | * Document/trigger/rule so changes to pg_shadow recreate pg_pwd I did it with a trigger and it seems to work like a charm. The function that already updates the file for create and alter user has been made a built-in "SQL" function and a trigger is created at initdb time. Comments around the pg_pwd updating function seem to be worried about this routine being called concurrently, but I really don't see a reason to worry about this. Verify for yourself. I guess we never had a system trigger before, so treat this with care, and feel free to adjust the nomenclature as well. -- Peter Eisentraut Sernanders väg 10:115
* Meanwhile, database names with single quotes in names don't work very wellBruce Momjian1999-12-12
| | | | | | | | | | | | | | | | | | | | | at all, and because of shell quoting rules this can't be fixed, so I put in error messages to that end. Also, calling create or drop database in a transaction block is not so good either, because the file system mysteriously refuses to roll back rm calls on transaction aborts. :) So I put in checks to see if a transaction is in progress and signal an error. Also I put the whole call in a transaction of its own to be able to roll back changes to pg_database in case the file system operations fail. The alternative location issues I posted recently were untouched, awaiting the outcome of that discussion. Other than that, this should be much more fool-proof now. The docs I cleaned up as well. Peter Eisentraut Sernanders väg 10:115
* Fix for psql from Peter.Bruce Momjian1999-12-11
|
* Allow ; in () in psql.Bruce Momjian1999-12-11
|
* This takes care of TODO itemBruce Momjian1999-12-11
| | | | | | | | | * pg_dump should preserve primary key information Also a couple of warnings removed. -- Peter Eisentraut Sernanders väg 10:115
* Remove old file.Bruce Momjian1999-12-10
|
* Update drop.sqlBruce Momjian1999-12-10
|
* Rename destroy.sql to drop.sql.Bruce Momjian1999-12-10
|
* Added global variable to have RI triggers overrideJan Wieck1999-12-10
| | | | | | time qualification of HeapTupleSatisfiesSnapshot() Jan
* Fix memory overrun while setting ps statusTatsuo Ishii1999-12-10
|
* Teach grammar and parser about aggregate(DISTINCT ...). No implementationTom Lane1999-12-10
| | | | | | | yet, but at least we can give a better error message: regression=> select count(distinct f1) from int4_tbl; ERROR: aggregate(DISTINCT ...) is not implemented yet instead of 'parser: parse error at or near distinct'.
* Remove unneeded action.Bruce Momjian1999-12-10
|
* Fix LDREL.Bruce Momjian1999-12-10
|
* This should fix the \e (\p, \g, ...) behaviour on an empty query buffer.Bruce Momjian1999-12-10
| | | | | | | | Also, minor tweakage of tab completion, and I hope the output is flushed on time now. -- Peter Eisentraut Sernanders väg 10:115
* Rename several destroy* functions/tags to drop*.Bruce Momjian1999-12-10
|
* Correct coredump in ALTER TABLE foo ADD(). Accept explicit NULL inTom Lane1999-12-10
| | | | | typecasts, eg 'NULL::text'. Later parts of the parser don't like this yet, but I'll work on that next.
* Update regression for new dropdb command.Bruce Momjian1999-12-10
|
* Added a fflush(stdout) to the \p command required for theJan Wieck1999-12-10
| | | | | | multisession test tool. Jan
* Make LD -r as macros that can be changed for QNX.Bruce Momjian1999-12-09
|
* Update for QNX from Kardos, Dr. AndreaBruce Momjian1999-12-09
|
* Replace generic 'Illegal use of aggregates' error message with one thatTom Lane1999-12-09
| | | | | shows the specific ungrouped variable being complained of. Perhaps this will reduce user confusion...
* Hi,Bruce Momjian1999-12-09
| | | | | | | | | | | | | | | | I was able to crash postgres 6.5.3 when I did an 'alter user' command. After I started a debugger I found the problem in the timezone handling of datetime (my Linux box lost its timezone information, that's how the problem occurred). Only 7 bytes are reserved for the timezone, without checking for boundaries. Attached is a patch that fixes this problem and emits a NOTICE if a timezone is encountered that is longer than MAXTZLEN bytes, like this: Jeroen van Vianen
* Remove extra vacuum, from Peter.Bruce Momjian1999-12-09
|
* Fixed concurrent visibility bug.Jan Wieck1999-12-08
| | | | Jan
* Fix indexing of cidr.Bruce Momjian1999-12-08
|
* CleanupBruce Momjian1999-12-08
|
* Change $< to $+ in scripts Makefile, and clean up pg_encoding if logic.Bruce Momjian1999-12-08
|
* *** empty log message ***Michael Meskes1999-12-08
|
* Peter's file removals.Bruce Momjian1999-12-07
|
* Okay, that should put us back in sync. These two patches (src & doc) areBruce Momjian1999-12-07
| | | | | | | | | | | | | | | against the sources from one hour ago and contain all the portable and up to date stuff. A few other CVS "householding" things you might want to take care of: * Remove the src/bin/cleardbdir directory * Remove the file src/bin/psql/sql_help.h from the repository, as it is a derived file and is build by the release_prep. Peter Eisentraut
* *** empty log message ***Michael Meskes1999-12-07
|
* Clean up memory leakage in find_inheritors() by using pg_list listsTom Lane1999-12-07
| | | | | | (which are palloc'd) instead of DLLists (which are malloc'd). Not very significant, since this routine seldom has anything useful to do, but a leak is a leak...
* Again updated INSIDE TODOJan Wieck1999-12-07
| | | | Jan
* Added SET DEFAULT action for ON DELETE/UPDATEJan Wieck1999-12-07
| | | | Jan
* Corrected TODO in sourceJan Wieck1999-12-06
| | | | Jan
* Added ON DELETE/UPDATE SET NULLJan Wieck1999-12-06
| | | | Jan
* Completed FOREIGN KEY syntax.Jan Wieck1999-12-06
| | | | | | | | Added functionality for automatic trigger creation during CREATE TABLE. Added ON DELETE RESTRICT and some others. Jan
* Fix the case of -o givenTatsuo Ishii1999-12-06
|
* Fix minor bugsTatsuo Ishii1999-12-06
|
* pg_ctl: a script to start/stop/restart and report status of postmaster.Tatsuo Ishii1999-12-06
|
* Fix bugs regarding pid file.Tatsuo Ishii1999-12-06
|
* Update rules test for extra quoting in rule deparser.Tom Lane1999-12-06
|
* Rule deparser needs to quote identifiers that are spelled the same asTom Lane1999-12-06
| | | | SQL keywords.
* Fix echo -n and read -r in scripts.Bruce Momjian1999-12-05
|
* Remove destroylang.sgml.Bruce Momjian1999-12-05
|
* UpdateBruce Momjian1999-12-05
|
* I cleaned those out as well (the echo -n "bug" was in there ;) and movedBruce Momjian1999-12-05
| | | | | | | | | | | | | | | | | | | | | | | | | them into the scripts dir. I also added a --list option to show already installed languages. This whole moving and renaming totally confused CVS and my checked out copy got completely fried last night. When you apply the source patch, please make sure that all the directories src/bin/{create|destroy}* as well as vacuumdb, cleardbdir are gone and that all the scripts (7) are in scripts/. Meanwhile I am still puzzled about what happened with the docs patch. Because I don't know what you got now, the second attachment contains the files ref/allfiles.sgml ref/commands.sgml ref/createlang.sgml ref/droplang.sgml doc/src/sgml/Makefile Peter Eisentraut Sernanders väg 10:115
* This *should* fix the large object segfault problem. Note linewrap mayBruce Momjian1999-12-05
| | | | | | be interfering with last line of patch. Vince.
* Unlink the pid file if it's bogus (no associated process exists)Tatsuo Ishii1999-12-04
|
* New scripts for create/drop user/db from Peter EisentrautBruce Momjian1999-12-04
|