aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Adjust the permissions required for COMMENT ON ROLE.Tom Lane2011-03-09
| | | | | | | | | | | | | | | | | | Formerly, any member of a role could change the role's comment, as of course could superusers; but holders of CREATEROLE privilege could not, unless they were also members. This led to the odd situation that a CREATEROLE holder could create a role but then could not comment on it. It also seems a bit dubious to let an unprivileged user change his own comment, let alone those of group roles he belongs to. So, change the rule to be "you must be superuser to comment on a superuser role, or hold CREATEROLE to comment on non-superuser roles". This is the same as the privilege check for creating/dropping roles, and thus fits much better with the rule for other object types, namely that only the owner of an object can comment on it. In passing, clean up the documentation for COMMENT a little bit. Per complaint from Owen Jacobson and subsequent discussion.
* Remove '=' from initdb switch syntax.Bruce Momjian2011-03-09
|
* Improve wording of initdb and pg_controldata manual pages.REL9_1_ALPHA4Bruce Momjian2011-03-09
| | | | gabrielle <gorthx@gmail.com>
* Remove 's' from recovery_target_timeline's' from the release note.Itagaki Takahiro2011-03-09
|
* synchronous_standby_names is a string parameter.Itagaki Takahiro2011-03-09
|
* Make alpha release notes more consistent as regards periods.Robert Haas2011-03-09
|
* Update alpha release notes for latest commits.Robert Haas2011-03-09
|
* A bit more editing for collation documentation.Tom Lane2011-03-08
|
* Create "replication and recovery" section in alpha release notes.Robert Haas2011-03-08
|
* Assorted editing for collation documentation.Tom Lane2011-03-08
| | | | | I made a pass over this to familiarize myself with the feature, and found some things that could be improved.
* Adjust CHAR() doc mention of pattern matching issues for trailingBruce Momjian2011-03-08
| | | | spaces.
* Document that char() ignores spaces in non-pattern comparisons, not inBruce Momjian2011-03-08
| | | | pattern comparisons such as LIKE and regex.
* Improve description of inquiry functions that accept regclass.Tom Lane2011-03-07
| | | | Per a suggestion from Thom Brown, though this is not his proposed patch.
* Minor copy-editing in CREATE TRIGGER reference page.Tom Lane2011-03-07
| | | | Per suggestions from Thom Brown and Robert Haas.
* If recovery_target_timeline is set to 'latest' and standby mode is enabled,Heikki Linnakangas2011-03-07
| | | | | | | | | | | | | | | | | periodically rescan the archive for new timelines, while waiting for new WAL segments to arrive. This allows you to set up a standby server that follows the TLI change if another standby server is promoted to master. Before this, you had to restart the standby server to make it notice the new timeline. This patch only scans the archive for TLI changes, it won't follow a TLI change in streaming replication. That is much needed too, but it would be a much bigger patch than I dare to sneak in this late in the release cycle. There was discussion on improving the sanity checking of the WAL segments so that the system would notice more reliably if the new timeline isn't an ancestor of the current one, but that is not included in this patch. Reviewed by Fujii Masao.
* Reword alpha release note item on SSI.Robert Haas2011-03-07
| | | | Per Josh Berkus; some additional explanatory text by me.
* Synchronous replication doc corrections.Robert Haas2011-03-07
| | | | Thom Brown
* Document the DEFERRABLE option in SET TRANSACTION command.Heikki Linnakangas2011-03-07
| | | | Kevin Grittner
* Efficient transaction-controlled synchronous replication.Simon Riggs2011-03-06
| | | | | | | | | | | | | | | | | | If a standby is broadcasting reply messages and we have named one or more standbys in synchronous_standby_names then allow users who set synchronous_replication to wait for commit, which then provides strict data integrity guarantees. Design avoids sending and receiving transaction state information so minimises bookkeeping overheads. We synchronize with the highest priority standby that is connected and ready to synchronize. Other standbys can be defined to takeover in case of standby failure. This version has very strict behaviour; more relaxed options may be added at a later date. Simon Riggs and Fujii Masao, with reviews by Yeb Havinga, Jaime Casanova, Heikki Linnakangas and Robert Haas, plus the assistance of many other design reviewers.
* Adjust documentation about pg_pltemplate to reflect latest thinking.Tom Lane2011-03-05
| | | | | It's more likely that pg_pltemplate will go away in the future than that we'll add additional specialized infrastructure for it.
* Make plpythonu language use plpython2 shared library directly.Tom Lane2011-03-05
| | | | | | | | | The original scheme for this was to symlink plpython.$DLSUFFIX to plpython2.$DLSUFFIX, but that doesn't work on Windows, and only accidentally failed to fail because of the way that CREATE LANGUAGE created or didn't create new C functions. My changes of yesterday exposed the weakness of that approach. To fix, get rid of the symlink and make pg_pltemplate show what's really going on.
* Convert createlang/droplang to use CREATE/DROP EXTENSION.Tom Lane2011-03-05
| | | | | | | | | | In createlang this is a one-line change. In droplang there's a whole lot of cruft that can be discarded since the extension mechanism now manages removal of the language's support functions. Also, add deprecation notices to these two programs' reference pages, since per discussion we may toss them overboard altogether in a release or two.
* Remove one copy of duplicated alpha4 release note.Robert Haas2011-03-05
| | | | Noted by Andy Colson
* Add missing word.Robert Haas2011-03-05
|
* First cut at 9.1alpha4 release notes.Robert Haas2011-03-05
|
* Remove emphasis from 9.1alpha3 items.Robert Haas2011-03-05
| | | | | In preparation for 9.1alpha4 release notes, where only the 9.1alpha4 features will be emphasized.
* Update documentation to reflect that standard PLs are now extensions.Tom Lane2011-03-05
| | | | | | Recommend use of CREATE EXTENSION rather than plain CREATE LANGUAGE where relevant. Encourage PL authors to provide extension wrappers for their PLs.
* Allow non-superusers to create (some) extensions.Tom Lane2011-03-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | Remove the unconditional superuser permissions check in CREATE EXTENSION, and instead define a "superuser" extension property, which when false (not the default) skips the superuser permissions check. In this case the calling user only needs enough permissions to execute the commands in the extension's installation script. The superuser property is also enforced in the same way for ALTER EXTENSION UPDATE cases. In other ALTER EXTENSION cases and DROP EXTENSION, test ownership of the extension rather than superuserness. ALTER EXTENSION ADD/DROP needs to insist on ownership of the target object as well; to do that without duplicating code, refactor comment.c's big switch for permissions checks into a separate function in objectaddress.c. I also removed the superuserness checks in pg_available_extensions and related functions; there's no strong reason why everybody shouldn't be able to see that info. Also invent an IF NOT EXISTS variant of CREATE EXTENSION, and use that in pg_dump, so that dumps won't fail for installed-by-default extensions. We don't have any of those yet, but we will soon. This is all per discussion of wrapping the standard procedural languages into extensions. I'll make those changes in a separate commit; this is just putting the core infrastructure in place.
* Add collations to information_schema.usage_privilegesPeter Eisentraut2011-03-02
| | | | This is faked information like for domains.
* Add 'collatable' to the Parameters section of CREATE TYPE.Tom Lane2011-03-02
|
* Add KNNGIST support to contrib/btree_gist.Tom Lane2011-03-02
| | | | | | | This extends GiST's support for nearest-neighbor searches to many of the standard data types. Teodor Sigaev
* Fix erroneous documentation of the syntax of CREATE CONSTRAINT TRIGGER.Tom Lane2011-03-02
| | | | | | | | 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.
* Correct mistaken claims about EXPLAIN ANALYZE's handling of triggers.Tom Lane2011-03-02
| | | | | | 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.
* Change pg_last_xlog_receive_location() not to move backwards. That makesHeikki Linnakangas2011-03-01
| | | | | | | | | | 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.
* Update discussion of EXPLAIN to reflect existence of ModifyTable nodes.Tom Lane2011-03-01
| | | | Back-patch to 9.0, since this was changed then.
* Avoid excessive Hot Standby feedback messages.Robert Haas2011-03-01
| | | | | | | | 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.
* PL/Python custom SPI exceptionsPeter Eisentraut2011-02-28
| | | | | | | | 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
* Add documentation for data-modifying statements in WITH clauses.Tom Lane2011-02-28
| | | | Marko Tiikkaja, somewhat reworked by Tom
* Document that last vacuum statistics and counts are for non-FULL vacuums.Bruce Momjian2011-02-27
|
* PL/Python explicit subtransactionsPeter Eisentraut2011-02-27
| | | | | | | 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
* Fix markup for pg_options_to_table() to report the return column names,Bruce Momjian2011-02-27
| | | | per suggestion from Andrew.
* Increase the default for wal_sender_delay from 200ms to 1s. Now that WALHeikki Linnakangas2011-02-26
| | | | | sender is immediately woken up by transaction commit, there's no need to wake up so aggressively.
* Document that pg_options_to_table() also works forBruce Momjian2011-02-26
| | | | pg_attribute.attoptions.
* Fix doc patch --- pg_options_to_table() returns "setof record".Bruce Momjian2011-02-26
|
* Table function support for PL/PythonPeter Eisentraut2011-02-26
| | | | | | | This allows functions with multiple OUT parameters returning both one or multiple records (RECORD or SETOF RECORD). Jan Urbański, reviewed by Hitoshi Harada
* Document pg_options_to_table() (not previously documented)Bruce Momjian2011-02-26
|
* Named restore point improvements.Robert Haas2011-02-24
| | | | | | | | 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.
* Update wording about information schema and name which views potentiallyBruce Momjian2011-02-22
| | | | can have duplicates, per request from Tom.
* Add PL/Python functions for quoting stringsPeter Eisentraut2011-02-22
| | | | | | | | | | | | 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
* Fix a couple of unlogged tables goofs.Robert Haas2011-02-22
| | | | | | | | "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.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-05 07:06:29 +0000