summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-03-02Some kibitzing about appropriate elog levels for sinval messages.Tom Lane
2002-03-02Commit to match discussed elog() changes. Only update is that LOG isBruce Momjian
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
2002-03-02Add code to allow profiling of backends on Linux: save and restore theTom Lane
profiling timer setting across fork(). The correct way to build a profilable backend on Linux is now gmake PROFILE="-pg -DLINUX_PROFILE"
2002-03-02Don't bother to request SSL connection over a Unix socket, since theTom Lane
postmaster won't accept the request anyway. (If your kernel can't be trusted, SSL will not help you.)
2002-03-02Array slice extraction should produce a result array with index lowerTom Lane
bounds of 1, not the lower bound subscripts of the original slice. Per bug report from Andre Holzner, 1-Feb-02.
2002-03-01User and database-specific session defaults for run-time configurationPeter Eisentraut
variables. New commands ALTER DATABASE ... SET and ALTER USER ... SET.
2002-03-01array_ref() should set isNull to false explicitly if it's not going toPeter Eisentraut
return NULL.
2002-03-01Fix thinko: cost_mergejoin must pay attention to which side of theTom Lane
mergeclause is which when extracting selectivity info.
2002-03-01Add files for Unicode support.Hiroshi Inoue
2002-03-01Second thoughts dept: arrange to cache mergejoin scan selectivityTom Lane
in RestrictInfo nodes, instead of recomputing on every use.
2002-03-01Teach planner about the idea that a mergejoin won't necessarily readTom Lane
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.
2002-02-27Tweak pg_exec_query_string so that we close down transaction commandTom Lane
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.
2002-02-27#ifdef out pg_dump's check on whether a sequence's sequence_name fieldTom Lane
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.
2002-02-27Paranoia about data structure lifetime ...Tom Lane
2002-02-27Clean up BeginCommand and related routines. BeginCommand and EndCommandTom Lane
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.
2002-02-27Improve the handling of ODBC escape(a request from Marcelo Aceto).Hiroshi Inoue
Change SQLGetFunctions() to reply not yet implemented ODBC 3.0 functions precisely.
2002-02-27Fix bug in COPY FROM when DELIMITER is not in ASCII range.Tatsuo Ishii
See pgsql-bugs/pgsql-hackers discussion "COPY FROM is not 8bit clean" around 2002/02/26 for more details -- Tatsuo Ishii
2002-02-26Restructure command-completion-report code so that there is just oneTom Lane
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.
2002-02-26Implementation for cancelQuery by Grant Finnemore <grantf@guruhut.co.za>Dave Cramer
2002-02-26Use quote-marks to try to clarify a plpgsql error message, perTom Lane
gripe from Dan Langille.
2002-02-25Tweak psql's \connect command to not downcase unquoted database and userTom Lane
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.
2002-02-25Fix for PAM error message display:Bruce Momjian
> 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
2002-02-25Add note that BLCKSZ must be a power of 2.Tom Lane
2002-02-25Add a large number of time zones to the lookup table.Thomas G. Lockhart
Fix a few apparently-wrong TZ vs DTZ declarations.
2002-02-25This patch will allow arbitrary levels of analyze / rewritingBruce Momjian
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
2002-02-25I've attached a simple patch which should improve the performance ofBruce Momjian
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
2002-02-25Re-add equals documentation with CREATE DATABASE.Bruce Momjian
2002-02-25Remove documentation of equals in CREATE DATABASE. Mention removal ofBruce Momjian
equals hack for the future.
2002-02-24Fix bogus createdb option syntax recommended by initlocation message.Tom Lane
2002-02-24Add -O/--owner switch to createdb script, in support of new OWNER optionTom Lane
for CREATE DATABASE.
2002-02-24Modify pg_dumpall so that output script uses new OWNER option of CREATETom Lane
DATABASE; also make it use SET SESSION AUTHORIZATION commands rather than \connect commands. This makes it possible to restore databases belonging to users who do not have CREATEDB privilege. It should also become at least somewhat feasible to run the restore script under password authentication --- you'll get one superuser password prompt per database, rather than a large number of challenges for passwords belonging to varying unspecified user names.
2002-02-24Add OWNER option to CREATE DATABASE, so superusers can create databasesTom Lane
on behalf of unprivileged users. Also, make '=' optional in CREATE DATABASE syntax. From Gavin Sherry, with kibitzing and docs by Tom Lane.
2002-02-24compiles correctly but still doesn't work with jdk 1.4Dave Cramer
2002-02-24pgindent copy.c. Patch wasn't in proper format.Bruce Momjian
2002-02-24Free files on dir open failure in COPY.Bruce Momjian
2002-02-23OK'ed by Peter.Bruce Momjian
The attached patch enables plperl to build under Cygwin. It is basically yet another BE_DLLLIBS patch with a perl MakeMaker twist. I tried the patch under Red Hat 7.1 Linux too and I did not observe any ill effects. Jason Tishler
2002-02-23Add fstat / S_ISDIR checks to make sure we're not trying to use aBruce Momjian
directory for COPY TO/FROM. Brent Verner
2002-02-23Feature patch per prev thread for --with-tcl, only affects AIXBruce Momjian
patch is low risc, thus could be applied now, but can also wait for 7.3 Old Makefile shows, that -bnoentry is available since 4.1 . Andreas Zeugswetter
2002-02-23Guard against createdb --location=PGDATA foo; without this, the codeTom Lane
tries to create a symlink pointing at itself. Per trouble report from Kenneth McDowell.
2002-02-23Heimdal support (Kerberos V implementation from KTH)Peter Eisentraut
2002-02-23Add -Wno-error to CFLAGS, so the rest of the tree can compile withPeter Eisentraut
-Werror.
2002-02-23Save source of GUC settings, allowing different sources to be processed inPeter Eisentraut
any order without affecting results.
2002-02-23Make factorial(0) return 1, as per spec.Bruce Momjian
2002-02-22We had a problem with to compile pgsql-7.2 under SW-8.0.Bruce Momjian
In the mailing lists I found no informations. See note for further informations. Add missing AuthBlockSig. regards Heiko
2002-02-22fixed compile errorDave Cramer
2002-02-22This patch fixes the exception thrown to inform the user the methodDave Cramer
getColumnClassName(int) is not implemented. This will futher fixes method ResultSet.getObject(int) since it requires the getColumnClassName(int) method to return the proper java class used to map the database column. auther Ed Yu
2002-02-22Patch from Cormac TwomeyDave Cramer
fixes getIndexInfo throwing NullPointerException fixes getIndexInfo improper results when multiple key indexs are used
2002-02-22Patch from Cormac TwomeyDave Cramer
fixes getIndexInfo throwing NullPointerException fixes getIndexInfo improper results when multiple key indexs are used
2002-02-22now compiles clean with jdk 1.4Dave Cramer
2002-02-20Fix comment.Tom Lane
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-05 03:08:01 +0000