summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2005-10-21Improve performance of CHECK_FOR_INTERRUPTS() macro on Windows by not doingTom Lane
a kernel call unless there's some evidence of a pending signal. This should bring its performance on Windows into line with the Unix version. Problem diagnosis and patch by Qingqing Zhou. Minor stylistic tweaks by moi ... if it's broken, it's my fault.
2005-10-21Clean up autovacuum documentation, which was a bit out of sync with whatTom Lane
the code actually does, and needed copy-editing anyway. Also take the opportunity to expand the section on routine reindexing.
2005-10-21Fix EXPLAIN ANALYZE bug noted by Wiebe Cazemier: although we wereTom Lane
properly advancing the CommandCounter between multiple sub-queries generated by rules, we forgot to update the snapshot being used, so that the successive sub-queries didn't actually see each others' results. This is still not *exactly* like the semantics of normal execution of the same queries, in that we don't take new transaction snapshots and hence don't see changes from concurrently committed commands, but I think that's OK and probably even preferable for EXPLAIN ANALYZE.
2005-10-21Add an implicit cast from varchar to regclass, so that existing codeTom Lane
of the form nextval('foo'::varchar) doesn't break. Per gripe from Jean-Pierre Pelletier. Initdb forced :-(
2005-10-21Add missing PQinitSSL and PQregisterThreadLock to exports.txt.Tom Lane
2005-10-21Update obsolete URL, per Chris.Tom Lane
2005-10-21Minor PL/PgSQL doc tweak: use current_timestamp rather than now() inNeil Conway
an example function.
2005-10-21Clean up some obsolete statements about GiST indexes, and add a sectionTom Lane
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.)
2005-10-20Improve testlibpq3.c's example of PQexecParams() usage to include sendingTom Lane
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.
2005-10-20Minor tweak to libpq documentation: make "PREPARE" and "DEALLOCATE" xrefs.Neil Conway
2005-10-20Postpone pg_timezone_initialize() until after creation of postmaster.pid,Tom Lane
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.
2005-10-20Document the behavior of GRANT/REVOKE in cases where the privilege isTom Lane
held by means of role membership, rather than directly. Per discussion and bug fix of a couple weeks ago.
2005-10-20Adjust not-too-sane calculation of DDD value for to_char(interval).Tom Lane
Per gripe from Chris Matheson.
2005-10-20Clean up md5.c to make it clearer that it is a frontend-and-backendTom Lane
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.
2005-10-20Make \d order a table's check constraints by constraint name insteadTom Lane
of the text of the constraint condition. Per Chris K-L, though I didn't use his patch exactly.
2005-10-19Better solution to the problem of labeling whole-row Datums that areTom Lane
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.
2005-10-19Ensure that the Datum generated from a whole-row Var contains validTom Lane
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.
2005-10-19Fix oversight in recent changes to enable the 'physical tlist'Tom Lane
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.
2005-10-18Improve trace_sort code to also show the total memory or disk space used.Tom Lane
Per request from Marc.
2005-10-18replace use of predefined perl vars $a and $b with $x and $y - per Greg ↵Andrew Dunstan
Sabino Mullane
2005-10-18Add an entry to the discussion of regression test failures about theTom Lane
possibility of a failure due to stack overflow when max_stack_depth is not set properly for the platform.
2005-10-18Code review for regexp_replace patch. Improve documentation and comments,Tom Lane
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.
2005-10-18Code review for spi_query/spi_fetchrow patch: handle errors sanely,Tom Lane
avoid leaking memory. I would add a regression test for error handling except it seems eval{} can't be used in unprivileged plperl :-(
2005-10-18When a cursor is opened using dblink_open, only start a transactionJoe Conway
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.
2005-10-18Fix several contrib makefiles that failed in VPATH builds, particularlyTom Lane
when not using gcc (which has slightly nonstandard inclusion rules).
2005-10-18A few trivial code cleanups motivated by reading warnings generatedTom Lane
by a recent HP C compiler. Mostly, get rid of useless local variables that are assigned to but never used.
2005-10-17Clean up libpq's pollution of application namespace by renaming theTom Lane
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.
2005-10-16Add note that some versions of OS X require SHMMAX to be an exact multipleTom Lane
of 4096. Also add comment explaining why we don't suggest using /etc/sysctl.conf to avoid needing to edit /etc/rc.
2005-10-16Add space after description.Bruce Momjian
Euler Taveira de Oliveira
2005-10-15kerberos error message: localhost -> server hostnameBruce Momjian
2005-10-15Suppress warnings on platforms where fprintf is a macro (eg, recentTom Lane
Fedora). This was already done by somebody for the core flex files, but these contrib files seem to have been missed.
2005-10-15Fix bogus error test in get_ti_Oid().Tom Lane
2005-10-15Fix unportable struct initializations.Tom Lane
2005-10-15Remove a long comment from cvs.sgml -- AFAICS this is no longer useful,Neil Conway
or at any rate doesn't belong as a comment in a random SGML file.
2005-10-15Fix assorted typos in the documentation, and use American spellingNeil Conway
rather than British. Patch from Michael Fuhr.
2005-10-15Fix thinko in pg_read_file: testing for negative result is not the wayTom Lane
to determine whether fread() failed.
2005-10-15Update 'supported platforms' list with current buildfarm results.Tom Lane
2005-10-15Fix kerberos description: localhost -> server hostname.Bruce Momjian
2005-10-15Standard pgindent run for 8.1.Bruce Momjian
2005-10-15Update pgindent typedef list.Bruce Momjian
2005-10-15Merge some user-submitted suggestions for improvement into theNeil Conway
documentation. Mostly add some <xref>s, fix a few typos, and document that zlib is required in the installation docs.
2005-10-15Fix typo.Alvaro Herrera
2005-10-14Fix syslog bug: if any messages are emitted to write_syslog beforeTom Lane
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.
2005-10-14fix nonsensical summary row on exampleAndrew Dunstan
2005-10-14Pass a strdup'd ident string to openlog(), to ensure that reallocationTom Lane
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.
2005-10-14Allow times of 24:00:00 to match rounding behavior:Bruce Momjian
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.
2005-10-13Add documentation mentioning that there are separate regression testsTom Lane
for the PL languages and for contrib.
2005-10-13Improve documentation about CREATEROLE privilege.Tom Lane
2005-10-13Fix uppercase TRUE/FALSE that are WIN32 stuffl.Bruce Momjian
2005-10-13Update regression output for new prepare transaction error messages.Bruce Momjian