aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Add an implicit cast from varchar to regclass, so that existing codeTom Lane2005-10-21
| | | | | of the form nextval('foo'::varchar) doesn't break. Per gripe from Jean-Pierre Pelletier. Initdb forced :-(
* Add missing PQinitSSL and PQregisterThreadLock to exports.txt.Tom Lane2005-10-21
|
* Update obsolete URL, per Chris.Tom Lane2005-10-21
|
* Minor PL/PgSQL doc tweak: use current_timestamp rather than now() inNeil Conway2005-10-21
| | | | an example function.
* Clean up some obsolete statements about GiST indexes, and add a sectionTom Lane2005-10-21
| | | | | | documenting GiST crash recovery procedures, as requested some time ago by Teodor. (The GiST chapter doesn't seem quite the right place for the latter, but I'm not sure what else to do with it.)
* Improve testlibpq3.c's example of PQexecParams() usage to include sendingTom Lane2005-10-20
| | | | | | | a parameter in binary format. Also, add a TIP explaining how to use casts in the query text to avoid needing to specify parameter types by OID. Also fix bogus spacing --- apparently somebody expanded the tabs in the example programs to 8 spaces instead of 4 when transposing them into SGML.
* Minor tweak to libpq documentation: make "PREPARE" and "DEALLOCATE" xrefs.Neil Conway2005-10-20
|
* Postpone pg_timezone_initialize() until after creation of postmaster.pid,Tom Lane2005-10-20
| | | | | | | since it can take a fair amount of time and this can confuse boot scripts that expect postmaster.pid to appear quickly. Move initialization of SSL library and preloaded libraries to after that point, too, just for luck. Per reports from Tony Caduto and others.
* Document the behavior of GRANT/REVOKE in cases where the privilege isTom Lane2005-10-20
| | | | | held by means of role membership, rather than directly. Per discussion and bug fix of a couple weeks ago.
* Adjust not-too-sane calculation of DDD value for to_char(interval).Tom Lane2005-10-20
| | | | Per gripe from Chris Matheson.
* Clean up md5.c to make it clearer that it is a frontend-and-backendTom Lane2005-10-20
| | | | | | | module. Don't rely on backend palloc semantics; in fact, best to not use palloc at all, rather than #define'ing it to malloc, because that just encourages errors of omission. Bug spotted by Volkan YAZICI, but I went further than he did to fix it.
* Make \d order a table's check constraints by constraint name insteadTom Lane2005-10-20
| | | | | of the text of the constraint condition. Per Chris K-L, though I didn't use his patch exactly.
* Better solution to the problem of labeling whole-row Datums that areTom Lane2005-10-19
| | | | | | generated from subquery outputs: use the type info stored in the Var itself. To avoid making ExecEvalVar and slot_getattr more complex and slower, I split out the whole-row case into a separate ExecEval routine.
* Ensure that the Datum generated from a whole-row Var contains validTom Lane2005-10-19
| | | | | | type ID information even when it's a record type. This is needed to handle whole-row Vars referencing subquery outputs. Per example from Richard Huxton.
* Fix oversight in recent changes to enable the 'physical tlist'Tom Lane2005-10-19
| | | | | | | | | optimization for subquery and function scan nodes: we can't just do it unconditionally, we still have to check whether there is any need for a whole-row Var. I had been thinking that these node types couldn't have any system columns, which is true, but that loop is also checking for attno zero, ie, whole-row Var. Fix comment to not be so misleading. Per test case from Richard Huxton.
* Improve trace_sort code to also show the total memory or disk space used.Tom Lane2005-10-18
| | | | Per request from Marc.
* replace use of predefined perl vars $a and $b with $x and $y - per Greg ↵Andrew Dunstan2005-10-18
| | | | Sabino Mullane
* Add an entry to the discussion of regression test failures about theTom Lane2005-10-18
| | | | | possibility of a failure due to stack overflow when max_stack_depth is not set properly for the platform.
* Code review for regexp_replace patch. Improve documentation and comments,Tom Lane2005-10-18
| | | | | | | fix problems with replacement-string backslashes that aren't followed by one of the expected characters, avoid giving the impression that replace_text_regexp() is meant to be called directly as a SQL function, etc.
* Code review for spi_query/spi_fetchrow patch: handle errors sanely,Tom Lane2005-10-18
| | | | | avoid leaking memory. I would add a regression test for error handling except it seems eval{} can't be used in unprivileged plperl :-(
* When a cursor is opened using dblink_open, only start a transactionJoe Conway2005-10-18
| | | | | | | | if there isn't one already open. Upon dblink_close, only commit the open transaction if it was started by dblink_open, and only then when all cursors opened by dblink_open are closed. The transaction accounting is done individually for all named connections, plus the persistent unnamed connection.
* Fix several contrib makefiles that failed in VPATH builds, particularlyTom Lane2005-10-18
| | | | when not using gcc (which has slightly nonstandard inclusion rules).
* A few trivial code cleanups motivated by reading warnings generatedTom Lane2005-10-18
| | | | | by a recent HP C compiler. Mostly, get rid of useless local variables that are assigned to but never used.
* Clean up libpq's pollution of application namespace by renaming theTom Lane2005-10-17
| | | | | | exported routines of ip.c, md5.c, and fe-auth.c to begin with 'pg_'. Also get rid of the vestigial fe_setauthsvc/fe_getauthsvc routines altogether.
* Add note that some versions of OS X require SHMMAX to be an exact multipleTom Lane2005-10-16
| | | | | of 4096. Also add comment explaining why we don't suggest using /etc/sysctl.conf to avoid needing to edit /etc/rc.
* Add space after description.Bruce Momjian2005-10-16
| | | | Euler Taveira de Oliveira
* kerberos error message: localhost -> server hostnameBruce Momjian2005-10-15
|
* Suppress warnings on platforms where fprintf is a macro (eg, recentTom Lane2005-10-15
| | | | | Fedora). This was already done by somebody for the core flex files, but these contrib files seem to have been missed.
* Fix bogus error test in get_ti_Oid().Tom Lane2005-10-15
|
* Fix unportable struct initializations.Tom Lane2005-10-15
|
* Remove a long comment from cvs.sgml -- AFAICS this is no longer useful,Neil Conway2005-10-15
| | | | or at any rate doesn't belong as a comment in a random SGML file.
* Fix assorted typos in the documentation, and use American spellingNeil Conway2005-10-15
| | | | rather than British. Patch from Michael Fuhr.
* Fix thinko in pg_read_file: testing for negative result is not the wayTom Lane2005-10-15
| | | | to determine whether fread() failed.
* Update 'supported platforms' list with current buildfarm results.Tom Lane2005-10-15
|
* Fix kerberos description: localhost -> server hostname.Bruce Momjian2005-10-15
|
* Standard pgindent run for 8.1.Bruce Momjian2005-10-15
|
* Update pgindent typedef list.Bruce Momjian2005-10-15
|
* Merge some user-submitted suggestions for improvement into theNeil Conway2005-10-15
| | | | | documentation. Mostly add some <xref>s, fix a few typos, and document that zlib is required in the installation docs.
* Fix typo.Alvaro Herrera2005-10-15
|
* Fix syslog bug: if any messages are emitted to write_syslog beforeTom Lane2005-10-14
| | | | | | | | | the facility has been set, the facility gets set to LOCAL0 and cannot be changed later. This seems reasonably plausible to happen, particularly at higher debug log levels, though I am not certain it explains Han Holl's recent report. Easiest fix is to teach the code how to change the value on-the-fly, which is nicer anyway. I made the settings PGC_SIGHUP to conform with log_destination.
* fix nonsensical summary row on exampleAndrew Dunstan2005-10-14
|
* Pass a strdup'd ident string to openlog(), to ensure that reallocationTom Lane2005-10-14
| | | | | of GUC memory doesn't cause us to start emitting a bogus ident string. Per report from Han Holl. Also some trivial code cleanup in write_syslog.
* Allow times of 24:00:00 to match rounding behavior:Bruce Momjian2005-10-14
| | | | | | | | | | | | | | | regression=# select '23:59:59.9'::time(0); time ---------- 24:00:00 (1 row) This is bad because: regression=# select '24:00:00'::time(0); ERROR: date/time field value out of range: "24:00:00" The last example now works.
* Add documentation mentioning that there are separate regression testsTom Lane2005-10-13
| | | | for the PL languages and for contrib.
* Improve documentation about CREATEROLE privilege.Tom Lane2005-10-13
|
* Fix uppercase TRUE/FALSE that are WIN32 stuffl.Bruce Momjian2005-10-13
|
* Update regression output for new prepare transaction error messages.Bruce Momjian2005-10-13
|
* Make stack_base_ptr non-static, for PL/Java.Bruce Momjian2005-10-13
|
* This makes the error messages for PREPARE TRANSACTION, COMMIT PREPAREDBruce Momjian2005-10-13
| | | | | | | etc. match the docs, which talk about "transaction identifier" not "gid" or "global transaction identifier". Steve Woodcock
* Update krb_server_name to document that a missing entry defaults toBruce Momjian2005-10-13
| | | | | | 'localhost'. Improve kerberos error message.