summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-03-02Fix erroneous documentation of the syntax of CREATE CONSTRAINT TRIGGER.Tom Lane
The grammar requires a specific ordering of the clauses, but the documentation showed a different order. This error was introduced in commit b47953f9c69d48a9261bd643e3170017b93f6337, which merged the CREATE CONSTRAINT TRIGGER documentation into the CREATE TRIGGER page. There is no code bug AFAICS.
2011-03-02Correct mistaken claims about EXPLAIN ANALYZE's handling of triggers.Tom Lane
Time spent executing AFTER triggers is not included in the runtime of the associated ModifyTable node; in my patch of yesterday I confused queuing of these triggers with their actual execution. Spotted by Marko Tiikkaja.
2011-03-01Change pg_last_xlog_receive_location() not to move backwards. That makesHeikki Linnakangas
it a lot more useful for determining which standby is most up-to-date, for example. There was long discussions on whether overwriting existing existing WAL makes sense to begin with, and whether we should do some more extensive variable renaming, but this change nevertheless seems quite uncontroversial. Fujii Masao, reviewed by Jeff Janes, Robert Haas, Stephen Frost.
2011-03-01Update discussion of EXPLAIN to reflect existence of ModifyTable nodes.Tom Lane
Back-patch to 9.0, since this was changed then.
2011-03-01Avoid excessive Hot Standby feedback messages.Robert Haas
Without this patch, when wal_receiver_status_interval=0, indicating that no status messages should be sent, Hot Standby feedback messages are instead sent extremely frequently. Fujii Masao, with documentation changes by me.
2011-02-28PL/Python custom SPI exceptionsPeter Eisentraut
This provides a separate exception class for each error code that the backend defines, as well as the ability to get the SQLSTATE from the exception object. Jan Urbański, reviewed by Steve Singer
2011-02-28Add documentation for data-modifying statements in WITH clauses.Tom Lane
Marko Tiikkaja, somewhat reworked by Tom
2011-02-27Document that last vacuum statistics and counts are for non-FULL vacuums.Bruce Momjian
2011-02-27PL/Python explicit subtransactionsPeter Eisentraut
Adds a context manager, obtainable by plpy.subtransaction(), to run a group of statements in a subtransaction. Jan Urbański, reviewed by Steve Singer, additional scribbling by me
2011-02-27Fix markup for pg_options_to_table() to report the return column names,Bruce Momjian
per suggestion from Andrew.
2011-02-26Increase the default for wal_sender_delay from 200ms to 1s. Now that WALHeikki Linnakangas
sender is immediately woken up by transaction commit, there's no need to wake up so aggressively.
2011-02-26Document that pg_options_to_table() also works forBruce Momjian
pg_attribute.attoptions.
2011-02-26Fix doc patch --- pg_options_to_table() returns "setof record".Bruce Momjian
2011-02-26Table function support for PL/PythonPeter Eisentraut
This allows functions with multiple OUT parameters returning both one or multiple records (RECORD or SETOF RECORD). Jan Urbański, reviewed by Hitoshi Harada
2011-02-26Document pg_options_to_table() (not previously documented)Bruce Momjian
2011-02-24Named restore point improvements.Robert Haas
Emit a log message when creating a named restore point, and improve documentation for pg_create_restore_point(). Euler Taveira de Oliveira, per suggestions from Thom Brown, with some additional wordsmithing by me.
2011-02-22Update wording about information schema and name which views potentiallyBruce Momjian
can have duplicates, per request from Tom.
2011-02-22Add PL/Python functions for quoting stringsPeter Eisentraut
Add functions plpy.quote_ident, plpy.quote_literal, plpy.quote_nullable, which wrap the equivalent SQL functions. To be able to propagate char * constness properly, make the argument of quote_literal_cstr() const char *. This also makes it more consistent with quote_identifier(). Jan Urbański, reviewed by Hitoshi Harada, some refinements by Peter Eisentraut
2011-02-22Fix a couple of unlogged tables goofs.Robert Haas
"SELECT ... INTO UNLOGGED tabname" works, but wasn't documented; CREATE UNLOGGED SEQUENCE and CREATE UNLOGGED VIEW failed an assertion, instead of throwing a sensible error. Latter issue reported by Itagaki Takahiro; patch review by Tom Lane.
2011-02-22Reword information_schema duplicate constraint warning text.Bruce Momjian
2011-02-21Move information_schema duplicate constraint note to the top of theBruce Momjian
information schema documentation because it affects several tables.
2011-02-21Update docs about new role privileges reference, per Alvaro.Bruce Momjian
2011-02-21Add ENCODING option to COPY TO/FROM and file_fdw.Itagaki Takahiro
File encodings can be specified separately from client encoding. If not specified, client encoding is used for backward compatibility. Cases when the encoding doesn't match client encoding are slower than matched cases because we don't have conversion procs for other encodings. Performance improvement would be be a future work. Original patch by Hitoshi Harada, and modified by me.
2011-02-20Merge two documentation permission chapters into a single chapter.Bruce Momjian
2011-02-20Add contrib/file_fdw foreign-data wrapper for reading files via COPY.Tom Lane
This is both very useful in its own right, and an important test case for the core FDW support. This commit includes a small refactoring of copy.c to expose its option checking code as a separately callable function. The original patch submission duplicated hundreds of lines of that code, which seemed pretty unmaintainable. Shigeru Hanada, reviewed by Itagaki Takahiro and Tom Lane
2011-02-20Implement an API to let foreign-data wrappers actually be functional.Tom Lane
This commit provides the core code and documentation needed. A contrib module test case will follow shortly. Shigeru Hanada, Jan Urbanski, Heikki Linnakangas
2011-02-20Adjust documentation wording of window function ORDER BY to not mentionBruce Momjian
avg() because it was inaccurate.
2011-02-19Documentation update for UTF16 surrogate pairs in UTF8 encoding.Bruce Momjian
Marko Kreen
2011-02-19Document that an SQL-standard-compliant query that expects a unique rowBruce Momjian
from information_schema.referential_constraints might return several in Postgres because we allow duplicate-named constraints in the same schema.
2011-02-19Set psql client encoding from locale by defaultPeter Eisentraut
Add a new libpq connection option client_encoding (which includes the existing PGCLIENTENCODING environment variable), which besides an encoding name accepts a special value "auto" that tries to determine the encoding from the locale in the client's environment, using the mechanisms that have been in use in initdb. psql sets this new connection option to "auto" when running from a terminal and not overridden by setting PGCLIENTENCODING. original code by Heikki Linnakangas, with subsequent contributions by Jaime Casanova, Peter Eisentraut, Stephen Frost, Ibrar Ahmed
2011-02-19Create the catalog infrastructure for foreign-data-wrapper handlers.Tom Lane
Add a fdwhandler column to pg_foreign_data_wrapper, plus HANDLER options in the CREATE FOREIGN DATA WRAPPER and ALTER FOREIGN DATA WRAPPER commands, plus pg_dump support for same. Also invent a new pseudotype fdw_handler with properties similar to language_handler. This is split out of the "FDW API" patch for ease of review; it's all stuff we will certainly need, regardless of any other details of the FDW API. FDW handler functions will not actually get called yet. In passing, fix some omissions and infelicities in foreigncmds.c. Shigeru Hanada, Jan Urbanski, Heikki Linnakangas
2011-02-18Improve text search prefix doc addition.Bruce Momjian
2011-02-18Document that text search comparisons happen after text searchBruce Momjian
configuration rules. Erik Rijkers
2011-02-18Add transaction-level advisory locks.Itagaki Takahiro
They share the same locking namespace with the existing session-level advisory locks, but they are automatically released at the end of the current transaction and cannot be released explicitly via unlock functions. Marko Tiikkaja, reviewed by me.
2011-02-17Convert Postgres arrays to Perl arrays on PL/perl input argumentsAlvaro Herrera
More generally, arrays are turned in Perl array references, and row and composite types are turned into Perl hash references. This is done recursively, in a way that's natural to every Perl programmer. To avoid a backwards compatibility hit, the string representation of each structure is also available if the function requests it. Authors: Alexey Klyukin and Alex Hunsaker. Some code cleanups by me.
2011-02-17Add client_hostname field to pg_stat_activity.Robert Haas
Peter Eisentraut, reviewed by Steve Singer, Alvaro Herrera, and me.
2011-02-17Typo fixBruce Momjian
Erik Rijkers
2011-02-17Remove doc mention about read committed in upsert example.Bruce Momjian
2011-02-17Document that plpgsql upsert example can fail if insert triggers returnBruce Momjian
unique exception, or if not used in read committed transaction mode.
2011-02-17In documentation example, use concat_values() instead of concat()Bruce Momjian
because concat() is a built-in function. Erik Rijkers
2011-02-17Typo fixes.Robert Haas
Thom Brown
2011-02-17Remove rule to build sepgsql-regtest.pp.Robert Haas
Instead, document how to build it manually. Per discussion. KaiGai Kohei, with some wordsmithing by me.
2011-02-16Hot Standby feedback for avoidance of cleanup conflicts on standby.Simon Riggs
Standby optionally sends back information about oldestXmin of queries which is then checked and applied to the WALSender's proc->xmin. GetOldestXmin() is modified slightly to agree with GetSnapshotData(), so that all backends on primary include WALSender within their snapshots. Note this does nothing to change the snapshot xmin on either master or standby. Feedback piggybacks on the standby reply message. vacuum_defer_cleanup_age is no longer used on standby, though parameter still exists on primary, since some use cases still exist. Simon Riggs, review comments from Fujii Masao, Heikki Linnakangas, Robert Haas
2011-02-16Add FOREACH IN ARRAY looping to plpgsql.Tom Lane
(I'm not entirely sure that we've finished bikeshedding the syntax details, but the functionality seems OK.) Pavel Stehule, reviewed by Stephen Frost and Tom Lane
2011-02-15pg_ctl promoteRobert Haas
Fujii Masao, reviewed by Robert Haas, Stephen Frost, and Magnus Hagander.
2011-02-15Assorted corrections to the patch to add WAL receiver replies.Robert Haas
Per reports from Fujii Masao.
2011-02-15Rename max_predicate_locks_per_transaction.Robert Haas
The new name, max_pred_locks_per_transaction, is shorter. Kevin Grittner, per discussion.
2011-02-14Avoid a few more SET DATA TYPE table rewrites.Robert Haas
When the new type is an unconstrained domain over the old type, we don't need to rewrite the table. Noah Misch and Robert Haas
2011-02-15Additional required docs for pg_constraint catalog entrySimon Riggs
Noted by Bernd Helmle
2011-02-14Rearrange extension-related views as per recent discussion.Tom Lane
The original design of pg_available_extensions did not consider the possibility of version-specific control files. Split it into two views: pg_available_extensions shows information that is generic about an extension, while pg_available_extension_versions shows all available versions together with information that could be version-dependent. Also, add an SRF pg_extension_update_paths() to assist in checking that a collection of update scripts provide sane update path sequences.
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-29 00:39:30 +0000