aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* 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.
* 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.
* 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 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.
* 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
* 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
* 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
|
* Add -O/--owner switch to createdb script, in support of new OWNER optionTom Lane2002-02-24
| | | | for CREATE DATABASE.
* Modify pg_dumpall so that output script uses new OWNER option of CREATETom Lane2002-02-24
| | | | | | | | | | 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.
* Add OWNER option to CREATE DATABASE, so superusers can create databasesTom Lane2002-02-24
| | | | | on behalf of unprivileged users. Also, make '=' optional in CREATE DATABASE syntax. From Gavin Sherry, with kibitzing and docs by Tom Lane.
* compiles correctly but still doesn't work with jdk 1.4Dave Cramer2002-02-24
|
* pgindent copy.c. Patch wasn't in proper format.Bruce Momjian2002-02-24
|
* Free files on dir open failure in COPY.Bruce Momjian2002-02-24
|
* OK'ed by Peter.Bruce Momjian2002-02-23
| | | | | | | | | 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
* Add fstat / S_ISDIR checks to make sure we're not trying to use aBruce Momjian2002-02-23
| | | | | | directory for COPY TO/FROM. Brent Verner
* Feature patch per prev thread for --with-tcl, only affects AIXBruce Momjian2002-02-23
| | | | | | | 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
* Guard against createdb --location=PGDATA foo; without this, the codeTom Lane2002-02-23
| | | | | tries to create a symlink pointing at itself. Per trouble report from Kenneth McDowell.
* Heimdal support (Kerberos V implementation from KTH)Peter Eisentraut2002-02-23
|
* Add -Wno-error to CFLAGS, so the rest of the tree can compile withPeter Eisentraut2002-02-23
| | | | -Werror.
* Save source of GUC settings, allowing different sources to be processed inPeter Eisentraut2002-02-23
| | | | any order without affecting results.
* Make factorial(0) return 1, as per spec.Bruce Momjian2002-02-23
|
* We had a problem with to compile pgsql-7.2 under SW-8.0.Bruce Momjian2002-02-22
| | | | | | | | | In the mailing lists I found no informations. See note for further informations. Add missing AuthBlockSig. regards Heiko
* fixed compile errorDave Cramer2002-02-22
|
* This patch fixes the exception thrown to inform the user the methodDave Cramer2002-02-22
| | | | | | | 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
* Patch from Cormac TwomeyDave Cramer2002-02-22
| | | | | fixes getIndexInfo throwing NullPointerException fixes getIndexInfo improper results when multiple key indexs are used
* Patch from Cormac TwomeyDave Cramer2002-02-22
| | | | | fixes getIndexInfo throwing NullPointerException fixes getIndexInfo improper results when multiple key indexs are used
* now compiles clean with jdk 1.4Dave Cramer2002-02-22
|
* Fix comment.Tom Lane2002-02-20
|
* Avoid failures in cash_out and cash_words for INT_MIN.Tom Lane2002-02-19
| | | | Also, 'fourty' -> 'forty'.
* Add casts to suppress gcc warnings on Solaris (where apparently pid_tTom Lane2002-02-19
| | | | is different from int).
* A bunch of changes aimed at reducing backend startup time...Tom Lane2002-02-19
| | | | | | | | | | | | | | | | | | | | | | | | | | Improve 'pg_internal.init' relcache entry preload mechanism so that it is safe to use for all system catalogs, and arrange to preload a realistic set of system-catalog entries instead of only the three nailed-in-cache indexes that were formerly loaded this way. Fix mechanism for deleting out-of-date pg_internal.init files: this must be synchronized with transaction commit, not just done at random times within transactions. Drive it off relcache invalidation mechanism so that no special-case tests are needed. Cache additional information in relcache entries for indexes (their pg_index tuples and index-operator OIDs) to eliminate repeated lookups. Also cache index opclass info at the per-opclass level to avoid repeated lookups during relcache load. Generalize 'systable scan' utilities originally developed by Hiroshi, move them into genam.c, use in a number of places where there was formerly ugly code for choosing either heap or index scan. In particular this allows simplification of the logic that prevents infinite recursion between syscache and relcache during startup: we can easily switch to heapscans in relcache.c when and where needed to avoid recursion, so IndexScanOK becomes simpler and does not need any expensive initialization. Eliminate useless opening of a heapscan data structure while doing an indexscan (this saves an mdnblocks call and thus at least one kernel call).
* Remove some unnecessary pqsignal() calls to shave a few cycles offTom Lane2002-02-19
| | | | backend startup.
* Arrange to call localtime() during postmaster startup. On most Unixen,Tom Lane2002-02-19
| | | | | | the first call of localtime() in a process will read /usr/lib/tztab or local equivalent. Better to do this once in the postmaster and inherit the data by fork() than to have to do it during every backend start.
* Avoid calling pq_flush just after sending AUTH_REQ_OK; this saves oneTom Lane2002-02-19
| | | | send() and probable process context swap during backend startup.
* Privileges on functions and procedural languagesPeter Eisentraut2002-02-18
|
* Replace number-of-distinct-values estimator equation, per recentTom Lane2002-02-18
| | | | pghackers discussion.
* Remove MAX/MIN() macros, use c.h Max/Min() instead.Bruce Momjian2002-02-18
|
* Disable LIMIT #,# syntax, as agreed to months ago. Print message sayingBruce Momjian2002-02-18
| | | | to use separate LIMIT/OFFSET clauses.
* Reorder postgresql.conf WAL section to be clearer.Bruce Momjian2002-02-18
|
* Don't mention TIOGA in Makefile and move strdup.c rule into properBruce Momjian2002-02-18
| | | | 'ifdef' in Makefile.
* Add code to preserve paren level display after \g, as submitted months ago.Bruce Momjian2002-02-18
|
* Remove compile warnings in multibute mode.Hiroshi Inoue2002-02-18
|
* Fix param handling of create* admin scripts as described months ago.Bruce Momjian2002-02-18
| | | | Properly handles default values.
* Add better error text:Bruce Momjian2002-02-18
| | | | | elog(LOG, "XLogWrite: new log file created - " "consider increasing 'wal_files' in postgresql.conf.");
* Add HTML output option to pgcvslog.Bruce Momjian2002-02-18
|