aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Update FAQ.Bruce Momjian2002-03-03
|
* Catcaches can now store negative entries as well as positive ones, toTom Lane2002-03-03
| | | | | | | | | | speed up repetitive failed searches; per pghackers discussion in late January. inval.c logic substantially simplified, since we can now treat inserts and deletes alike as far as inval events are concerned. Some repair work needed in heap_create_with_catalog, which turns out to have been doing CommandCounterIncrement at a point where the new relation has non-self-consistent catalog entries. With the new inval code, that resulted in assert failures during a relcache entry rebuild.
* Update FAQ.Bruce Momjian2002-03-03
|
* Default server_min_messages is NOTICE.Bruce Momjian2002-03-03
|
* Cause regression tests to pass again after elog changes.Tom Lane2002-03-03
|
* Some kibitzing about appropriate elog levels for sinval messages.Tom Lane2002-03-02
|
* Commit to match discussed elog() changes. Only update is that LOG isBruce Momjian2002-03-02
| | | | | | | | | | | | | | | | | | | | | | | | | | | now just below FATAL in server_min_messages. Added more text to highlight ordering difference between it and client_min_messages. --------------------------------------------------------------------------- REALLYFATAL => PANIC STOP => PANIC New INFO level the prints to client by default New LOG level the prints to server log by default Cause VACUUM information to print only to the client NOTICE => INFO where purely information messages are sent DEBUG => LOG for purely server status messages DEBUG removed, kept as backward compatible DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1 added DebugLvl removed in favor of new DEBUG[1-5] symbols New server_min_messages GUC parameter with values: DEBUG[5-1], INFO, NOTICE, ERROR, LOG, FATAL, PANIC New client_min_messages GUC parameter with values: DEBUG[5-1], LOG, INFO, NOTICE, ERROR, FATAL, PANIC Server startup now logged with LOG instead of DEBUG Remove debug_level GUC parameter elog() numbers now start at 10 Add test to print error message if older elog() values are passed to elog() Bootstrap mode now has a -d that requires an argument, like postmaster
* Add code to allow profiling of backends on Linux: save and restore theTom Lane2002-03-02
| | | | | profiling timer setting across fork(). The correct way to build a profilable backend on Linux is now gmake PROFILE="-pg -DLINUX_PROFILE"
* Don't bother to request SSL connection over a Unix socket, since theTom Lane2002-03-02
| | | | | postmaster won't accept the request anyway. (If your kernel can't be trusted, SSL will not help you.)
* Array slice extraction should produce a result array with index lowerTom Lane2002-03-02
| | | | | bounds of 1, not the lower bound subscripts of the original slice. Per bug report from Andre Holzner, 1-Feb-02.
* User and database-specific session defaults for run-time configurationPeter Eisentraut2002-03-01
| | | | variables. New commands ALTER DATABASE ... SET and ALTER USER ... SET.
* array_ref() should set isNull to false explicitly if it's not going toPeter Eisentraut2002-03-01
| | | | return NULL.
* Fix thinko: cost_mergejoin must pay attention to which side of theTom Lane2002-03-01
| | | | mergeclause is which when extracting selectivity info.
* Revert quotes, 7.2 doesn't need them for CREATE FUNCTION.Bruce Momjian2002-03-01
|
* Oops, we didn't have single quotes around 'langname' in CREATE FUNCTIONBruce Momjian2002-03-01
| | | | manual page; pointed out by IRC user.
* Add files for Unicode support.Hiroshi Inoue2002-03-01
|
* Second thoughts dept: arrange to cache mergejoin scan selectivityTom Lane2002-03-01
| | | | in RestrictInfo nodes, instead of recomputing on every use.
* Teach planner about the idea that a mergejoin won't necessarily readTom Lane2002-03-01
| | | | | | both input streams to the end. If one variable's range is much less than the other, an indexscan-based merge can win by not scanning all of the other table. Per example from Reinhard Max.
* Tweak pg_exec_query_string so that we close down transaction commandTom Lane2002-02-27
| | | | | | | | | before reporting command-complete message for the final command of a query string. This way, any errors detected during finish_xact_command (such as RI violations) will appear to be part of the final command, rather than coming out after the command is reported complete. This avoids confusing PQendcopy and other not-overly-bright clients. Per Lee Harr's bug report of 25-Feb-02.
* Some cleanups in CREATE/ALTER/DROP USER ref pages.Peter Eisentraut2002-02-27
|
* #ifdef out pg_dump's check on whether a sequence's sequence_name fieldTom Lane2002-02-27
| | | | | | matches the sequence name from pg_class. This fails if the sequence has been renamed, and seems rather pointless in any case. Also improve a couple of error messages about inconsistencies.
* Paranoia about data structure lifetime ...Tom Lane2002-02-27
|
* Clean up BeginCommand and related routines. BeginCommand and EndCommandTom Lane2002-02-27
| | | | | | | | | | | are now both invoked once per received SQL command (raw parsetree) from pg_exec_query_string. BeginCommand is actually just an empty routine at the moment --- all its former operations have been pushed into tuple receiver setup routines in printtup.c. This makes for a clean distinction between BeginCommand/EndCommand (once per command) and the tuple receiver setup/teardown routines (once per ExecutorRun call), whereas the old code was quite ad hoc. Along the way, clean up the calling conventions for ExecutorRun a little bit.
* Update FAQ.Bruce Momjian2002-02-27
|
* Improve the handling of ODBC escape(a request from Marcelo Aceto).Hiroshi Inoue2002-02-27
| | | | | Change SQLGetFunctions() to reply not yet implemented ODBC 3.0 functions precisely.
* Fix bug in COPY FROM when DELIMITER is not in ASCII range.Tatsuo Ishii2002-02-27
| | | | | See pgsql-bugs/pgsql-hackers discussion "COPY FROM is not 8bit clean" around 2002/02/26 for more details -- Tatsuo Ishii
* Restructure command-completion-report code so that there is just oneTom Lane2002-02-26
| | | | | | | report for each received SQL command, regardless of rewriting activity. Also ensure that this report comes from the 'original' command, not the last command generated by rewrite; this fixes 7.2 breakage for INSERT commands that have actions added by rules. Fernando Nasser and Tom Lane.
* Correct typo noticed by Christopher Kings-Lynne.Tom Lane2002-02-26
|
* Implementation for cancelQuery by Grant Finnemore <grantf@guruhut.co.za>Dave Cramer2002-02-26
|
* Use quote-marks to try to clarify a plpgsql error message, perTom Lane2002-02-26
| | | | gripe from Dan Langille.
* Tweak psql's \connect command to not downcase unquoted database and userTom Lane2002-02-25
| | | | | | | | names. This is a temporary measure to allow backwards compatibility with 7.2 and earlier pg_dump. 7.2.1 and later pg_dump will double-quote mixed case names in \connect. Once we feel that older dumps are not a problem anymore, we can revert this change and treat \connect arguments as normal SQL identifiers.
* Added:Bruce Momjian2002-02-25
| | | | > * Remove memory/file descriptor freeing befor elog(ERROR) (Bruce)
* Update FAQ_DEV.Bruce Momjian2002-02-25
|
* Update FAQ.Bruce Momjian2002-02-25
|
* Fix for PAM error message display:Bruce Momjian2002-02-25
| | | | | | | > and that the right fix is to make each of the subsequent calls be in > this same pattern, not to try to emulate their nonsensical style. Dominic J. Eidson
* Add items and JDBC maintainers:Bruce Momjian2002-02-25
| | | | | | | | > o Add LISTEN/NOTIFY support to the JDBC driver (Barry) 479a481 > * Barry is Barry Lind <barry@xythos.com> 482a485 > * Dave is Dave Cramer <dave@fastcrypt.com>
* Add note that BLCKSZ must be a power of 2.Tom Lane2002-02-25
|
* Add a large number of time zones to the lookup table.Thomas G. Lockhart2002-02-25
| | | | Fix a few apparently-wrong TZ vs DTZ declarations.
* Update completed items:Bruce Momjian2002-02-25
| | | | | | | > * -Prevent SIGHUP and 'pg_ctl reload' from changing command line > * -Remove LIMIT #,# and force use LIMIT and OFFSET clauses in 7.3 (Bruce) > * -Prevent create/drop scripts from allowing extra args (Bruce) > * -Have pg_dump -C dump database location and encoding information
* This patch will allow arbitrary levels of analyze / rewritingBruce Momjian2002-02-25
| | | | | | | | | | | | | | | | | | by making the static variables extra_before and extra_after automatic so we can use recursion. It gets much easier to generate extra commands now, and one can rest assured that the extra commands will be properly analyzed/rewritten. Without this patch, if a command produced by transformation tries to use these static lists their first contents would be lost with unpredictable results. I know I could fix this by just using nconc() instead of assignments, but the resulting order of the commands would not be exactly what one could expect. -- Fernando Nasser
* Try to make makefile actually work ...Tom Lane2002-02-25
|
* Fix typo in Makefile.Bruce Momjian2002-02-25
|
* I've attached a simple patch which should improve the performance ofBruce Momjian2002-02-25
| | | | | | | | | | | | | | hashname() and reduce the penalty incured when NAMEDATALEN is increased. I posted this to -hackers a couple days ago, and there haven't been any major complaints. It passes the regression tests. See -hackers for more discussion, as well as the suggestion from Tom Lane on which this patch is based. Unless anyone sees any problems, please apply for 7.3. Cheers, Neil Conway
* Fix typo in filename.Bruce Momjian2002-02-25
|
* Add integer aggregator to /contrib.Bruce Momjian2002-02-25
| | | | mlw
* *** empty log message ***Bruce Momjian2002-02-25
|
* Re-add equals documentation with CREATE DATABASE.Bruce Momjian2002-02-25
|
* Remove documentation of equals in CREATE DATABASE. Mention removal ofBruce Momjian2002-02-25
| | | | equals hack for the future.
* Fix bogus createdb option syntax recommended by initlocation message.Tom Lane2002-02-24
|
* Fix copy-and-paste typo.Tom Lane2002-02-24
|