summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2010-07-03Fix assorted misstatements and poor wording in the descriptions of the I/OTom Lane
formats for geometric types. Per bug #5536 from Jon Strait, and my own testing. Back-patch to all supported branches, since this doco has been wrong right along -- we certainly haven't changed the I/O behavior of these types in many years.
2010-07-03Additional cross-references to window functions documentation.Robert Haas
Erik Rijkers
2010-07-02Unbreak MSVC builds by removing copydir.c from list of libpgport filesAndrew Dunstan
2010-07-02Remove hstore % text[] operator; use slice() function instead.Robert Haas
David Wheeler, with one small correction by me.
2010-07-02Move copydir.c from src/port to src/backend/storage/fileRobert Haas
The previous commit to make copydir() interruptible prevented postgres.exe from linking on MinGW and Cygwin, because on those platforms libpgport_srv.a can't freely reference symbols defined by the backend. Since that code is already backend-specific anyway, just move the whole file into the backend rather than adding further kludges to deal with the symbols needed by CHECK_FOR_INTERRUPTS(). This probably needs some further cleanup, but this commit just moves the file as-is, which should hopefully be enough to turn the buildfarm green again.
2010-07-02Issue 'mkdir' hint when replying CREATE TABLESPACE in recovery mode.Bruce Momjian
Per idea from Fujii Masao
2010-07-01Allow copydir() to be interrupted.Robert Haas
This makes ALTER DATABASE .. SET TABLESPACE and CREATE DATABASE more sensitive to interrupts. Backpatch to 8.4, where ALTER DATABASE .. SET TABLESPACE was introduced. We could go back further, but in the absence of complaints about the CREATE DATABASE case it doesn't seem worth it. Guillaume Lelarge, with a small correction by me.
2010-07-01Get rid of some more stuff that duplicates c.h or port.h.Tom Lane
2010-07-01Remove port.h prototypes from pg_upgrade.h, per report from Robert Haas.Bruce Momjian
2010-07-01Allow ALTER TABLE .. SET TABLESPACE to be interrupted.Robert Haas
Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge
2010-07-01Update 9.0 release notes so streaming replication and hot standby is notBruce Momjian
assumed to require continuous archiving. Per report from Fujii Masao
2010-06-30stringToNode() and deparse_expression_pretty() crash on invalid input,Heikki Linnakangas
but we have nevertheless exposed them to users via pg_get_expr(). It would be too much maintenance effort to rigorously check the input, so put a hack in place instead to restrict pg_get_expr() so that the argument must come from one of the system catalog columns known to contain valid expressions. Per report from Rushabh Lathia. Backpatch to 7.4 which is the oldest supported version at the moment.
2010-06-30Correct missing/misspelled surname.Andrew Dunstan
2010-06-30Document that /bin/true on Windows is implemented by 'REM'.Bruce Momjian
2010-06-29In documentation, use "lower case"/"upper case" consistently (use spaceBruce Momjian
between words).
2010-06-29Document that shared_preload_libraries and local_preload_librariesBruce Momjian
lowercase the library names, unless double-quoted.
2010-06-29Add compatibility note warning that plpgsql is now stricter about the columnTom Lane
datatypes of composite results, per gripe from Marcel Asio. Some desultory copy-editing of plpgsql-related sections of the release notes.
2010-06-29Add C comment about why synchronous_commit=off behavior can loseBruce Momjian
committed transactions in a postmaster crash.
2010-06-29Message tuningPeter Eisentraut
2010-06-29Use different function names for plpython3 handlers, to avoid clashes inPeter Eisentraut
pg_pltemplate This should have a catversion bump, but it's still being debated whether it's worth it during beta.
2010-06-29Add note clarifying that XML fragments don't accept DTDsPeter Eisentraut
per complaint from Craig Ringer
2010-06-28Fix doc double-wording in non-durable patch.Bruce Momjian
Report from Thom Brown
2010-06-28Add new Non-Durable Settings documentation section.Bruce Momjian
Document that synchronous_commit can lose transactions in a db crash, not just a OS crash.
2010-06-28emode_for_corrupt_record shouldn't reduce LOG messages to WARNING.Robert Haas
In non-interactive sessions, WARNING sorts below LOG.
2010-06-28Add guidelines for formatting errcontext stringsPeter Eisentraut
2010-06-28Remove tab from SGML.Bruce Momjian
2010-06-28Improve pg_dump's checkSeek() function to verify the functioning of ftelloTom Lane
as well as fseeko, and to not assume that fseeko(fp, 0, SEEK_CUR) proves anything. Also improve some related comments. Per my observation that the SEEK_CUR test didn't actually work on some platforms, and subsequent discussion with Robert Haas. Back-patch to 8.4. In earlier releases it's not that important whether we get the hasSeek test right, but with parallel restore it matters.
2010-06-27Fix pg_restore so parallel restore doesn't fail when the input file doesn'tTom Lane
contain data offsets (which it won't, if pg_dump thought its output wasn't seekable). To do that, remove an unnecessarily aggressive error check, and instead fail if we get to the end of the archive without finding the desired data item. Also improve the error message to be more specific about the cause of the problem. Per discussion of recent report from Igor Neyman. Back-patch to 8.4 where parallel restore was introduced.
2010-06-25Rewrite docs for new libpq keepalive parameters.Robert Haas
The revised documentation makes it more clear that these are client-side parameters, rather than server side parameters. It also puts the main point of each parameter first, and consolidates the conditions under which it might be ignored in a single list at the end.
2010-06-25Make AIX suggestions about disabling ipv6 more version-sensitive.Robert Haas
Chris Browne, based on a report from John Pierce.
2010-06-25Fix thinko in tok_is_keyword(): it was looking at the wrong union variantTom Lane
of YYSTYPE, and hence returning the wrong answer for cases where a plpgsql "unreserved keyword" really does conflict with a variable name. Obviously I didn't test this enough :-(. Per bug #5524 from Peter Gagarinov.
2010-06-25Fix log_temp_files docs and comments to say bytes not kilobytes.Simon Riggs
stat(2) field st_size returns bytes not kilobytes. Bug found during recent performance tuning for PostgreSQL user.
2010-06-24Some copy-editing of the Hot Standby documentation.Robert Haas
Thanks to Joshua Tolley for the review.
2010-06-24Further 9.0 release notes updates.Robert Haas
Josh Berkus
2010-06-24Add stray "else" that seems to have gone missing.Robert Haas
2010-06-24Mention that when alter rewrites a table, indexes are also rebuilt.Bruce Momjian
2010-06-23Add TCP keepalive support to libpq.Robert Haas
This adds four additional connection parameters to libpq: keepalives, keepalives_idle, keepalives_count, and keepalives_interval. keepalives default to on, per discussion, but can be turned off by specifying keepalives=0. The remaining parameters, where supported, can be used to adjust how often keepalives are sent and how many can be lost before the connection is broken. The immediate motivation for this patch is to make sure that walreceiver will eventually notice if the master reboots without closing the connection cleanly, but it should be helpful in other cases as well. Tollef Fog Heen, Fujii Masao, and me.
2010-06-23Add username designations to all pg_upgrade utility calls that support it.Bruce Momjian
2010-06-22Fix pg_upgrade's use of pg_ctl on Win32 to not send command and severBruce Momjian
output to the same file, because it is impossible. Also set user name for pg_dumpall in pg_upgrade.
2010-06-22Update pg_ctl docs to explain server output behavior differences onBruce Momjian
win32 and non-win32 platforms.
2010-06-22Updated expected-output file for hstore.Robert Haas
This is an oversight in my previous patch to deprecate => as an operator name. Per buildfarm.
2010-06-22Deprecate the use of => as an operator name.Robert Haas
In HEAD, emit a warning when an operator named => is defined. In both HEAD and the backbranches (except in 8.2, where contrib modules do not have documentation), document that hstore's text => text operator may be removed in a future release, and encourage the use of the hstore(text, text) function instead. This function only exists in HEAD (previously, it was called tconvert), so backpatch it back to 8.2, when hstore was added. Per discussion.
2010-06-22Minor markup improvements for Hot Standby documentation.Robert Haas
2010-06-21In a PL/pgSQL "FOR cursor" statement, the statements executed in the loopHeikki Linnakangas
might close the cursor, rendering the Portal pointer to it invalid. Closing the cursor in the middle of the loop is not a very sensible thing to do, but we must handle it gracefully and throw an error instead of crashing.
2010-06-21Fix mishandling of whole-row Vars referencing a view or sub-select.Tom Lane
If such a Var appeared within a nested sub-select, we failed to translate it correctly during pullup of the view, because the recursive call to replace_rte_variables_mutator was looking for the wrong sublevels_up value. Bug was introduced during the addition of the PlaceHolderVar mechanism. Per bug #5514 from Marcos Castedo.
2010-06-18Rename hstore => text[] operator to %Robert Haas
This is not yet in any released version, so we still have the option to change the name. We may want to reserve the token => in a future release.
2010-06-17Clean up some randomness associated with trace_recovery_messages: don'tTom Lane
put the variable declaration in the middle of a bunch of externs, and do use extern where it should be used.
2010-06-17Make RemoveOldXlogFiles's debug printout match style used elsewhere:Tom Lane
log and seg aren't an XLogRecPtr and shouldn't be printed like one. Fujii Masao
2010-06-17Clean up pg_archivecleanup's error and logging output: put newlines inTom Lane
sane places, make messages follow project's message style guidelines. Also, avoid closedir(NULL). Fujii Masao and Tom Lane
2010-06-17Add missing close brackets in old-style COPY syntax diagram.Tom Lane
Spotted by Evan Carroll.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-28 21:01:50 +0000