aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Make xpath() do something useful with XPath expressions that return scalars.Tom Lane2011-07-21
| | | | | | | | | | | | | Previously, xpath() simply returned an empty array if the expression did not yield a node set. This is useless for expressions that return scalars, such as one with name() at the top level. Arrange to return the scalar value as a single-element xml array, instead. (String values will be suitably escaped.) This change will also cause xpath_exists() to return true, not false, for such expressions. Florian Pflug, reviewed by Radoslaw Smogura
* Support SECURITY LABEL on databases, tablespaces, and roles.Robert Haas2011-07-20
| | | | | | | | | | | This requires a new shared catalog, pg_shseclabel. Along the way, fix the security_label regression tests so that they don't monkey with the labels of any pre-existing objects. This is unlikely to matter in practice, since only the label for the "dummy" provider was being manipulated. But this way still seems cleaner. KaiGai Kohei, with fairly extensive hacking by me.
* Improve sepgsql and SECURITY LABEL documentation.Robert Haas2011-07-20
| | | | | KaiGai Kohei, based on feedback from Yeb Havinga, with some corrections by me.
* Minor improvement to pg_seclabel documentation.Robert Haas2011-07-20
| | | | | This is a bit more consistent with the way pg_description is documented, and also include a useful cross-link.
* Minor doc additions for cascading replication.Simon Riggs2011-07-19
|
* Cascading replication feature for streaming log-based replication.Simon Riggs2011-07-19
| | | | | | | | | Standby servers can now have WALSender processes, which can work with either WALReceiver or archive_commands to pass data. Fully updated docs, including new conceptual terms of sending server, upstream and downstream servers. WALSenders terminated when promote to master. Fujii Masao, review, rework and doc rewrite by Simon Riggs
* Add GET STACKED DIAGNOSTICS plpgsql command to retrieve exception info.Tom Lane2011-07-18
| | | | | | | This is more SQL-spec-compliant, more easily extensible, and better performing than the old method of inventing special variables. Pavel Stehule, reviewed by Shigeru Hanada and David Wheeler
* Avoid index rebuild for no-rewrite ALTER TABLE .. ALTER TYPE.Robert Haas2011-07-18
| | | | Noah Misch. Review and minor cosmetic changes by me.
* Create a "fast path" for acquiring weak relation locks.Robert Haas2011-07-18
| | | | | | | | | | | | | | | | | When an AccessShareLock, RowShareLock, or RowExclusiveLock is requested on an unshared database relation, and we can verify that no conflicting locks can possibly be present, record the lock in a per-backend queue, stored within the PGPROC, rather than in the primary lock table. This eliminates a great deal of contention on the lock manager LWLocks. This patch also refactors the interface between GetLockStatusData() and pg_lock_status() to be a bit more abstract, so that we don't rely so heavily on the lock manager's internal representation details. The new fast path lock structures don't have a LOCK or PROCLOCK structure to return, so we mustn't depend on that for purposes of listing outstanding locks. Review by Jeff Davis.
* Remove claim that the project is not represented in the SQL working groupPeter Eisentraut2011-07-18
| | | | We have a few people involved there now.
* Note that information_schema.sql_languages was removed in SQL:2008Peter Eisentraut2011-07-18
|
* Add pg_opfamily_is_visible.Robert Haas2011-07-17
| | | | | | | We already have similar functions for many other object types, including operator classes, so it seems like we should have this one, too. Extracted from a larger patch by Josh Kupershmidt
* Add temp_file_limit GUC parameter to constrain temporary file space usage.Tom Lane2011-07-17
| | | | | | | The limit is enforced against the total amount of temp file space used by each session. Mark Kirkwood, reviewed by Cédric Villemain and Tatsuo Ishii
* Add an errdetail_internal() ereport auxiliary routine.Tom Lane2011-07-16
| | | | | | | | | This function supports untranslated detail messages, in the same way that errmsg_internal supports untranslated primary messages. We've needed this for some time IMO, but discussion of some cases in the SSI code provided the impetus to actually add it. Kevin Grittner, with minor adjustments by me
* Set information_schema.tables.commit_action to nullPeter Eisentraut2011-07-15
| | | | | | The commit action of temporary tables is currently not cataloged, so we can't easily show it. The previous value was outdated from before we had different commit actions.
* Doc clarification for pg_locks columns.Bruce Momjian2011-07-15
| | | | Florian Pflug
* In docs, start window function sentence with "The asterisk (*)" ratherBruce Momjian2011-07-14
| | | | than "*"; it is confusing to start a sentence with a symbol.
* Fix broken markupAlvaro Herrera2011-07-14
|
* Set information_schema.routines.is_udt_dependent to NOPeter Eisentraut2011-07-14
| | | | It previously said YES, but that is incorrect.
* Small update on suggested startup file locationsPeter Eisentraut2011-07-14
| | | | | Debian/Ubuntu don't have a /etc/rc.d/ directory, so add some alternative names as suggestions.
* Implement information schema interval_type columnsPeter Eisentraut2011-07-13
| | | | | Also correct reporting of interval precision when field restrictions are specified in the typmod.
* Use clearer woring for pg_locks columns, identifying which items areBruce Momjian2011-07-13
| | | | related to lock objects.
* Fix and clarify information schema interval_precision fieldsPeter Eisentraut2011-07-11
| | | | | | | | The fields were previously wrongly typed as character_data; change to cardinal_number. Update the documentation and the implementation to show more clearly that this applies to a feature not available in PostgreSQL, rather than just not yet being implemented in the information schema.
* Improve wording of documentation on default privileges.Andrew Dunstan2011-07-11
| | | | Per recent -hackers discussion.
* Add item about Clang support to 9.1 release notesPeter Eisentraut2011-07-08
|
* Message style improvementsPeter Eisentraut2011-07-08
|
* Update examples for string-related functions.Tom Lane2011-07-07
| | | | | | | | | | | | | In the example for decode(), show the bytea result in hex format, since that's now the default. Use an E'' string in the example for quote_literal(), so that it works regardless of the standard_conforming_strings setting. On the functions-for-binary-strings page, leave the examples as-is for readability, but add a note pointing out that they are shown in escape format. Per comments from Thom Brown. Also, improve the description for encode() and decode() a tad. Backpatch to 9.0, where bytea_output was introduced.
* Update 9.1 release notes to reflect commits through today.Tom Lane2011-07-07
|
* Reclassify replication-related GUC variables as "master" and "standby".Tom Lane2011-07-07
| | | | | | | Per discussion, this structure seems more understandable than what was there before. Make config.sgml and postgresql.conf.sample agree. In passing do a bit of editorial work on the variable descriptions.
* Finish disabling reduced-lock-levels-for-DDL feature.Tom Lane2011-07-07
| | | | | Previous patch only covered the ALTER TABLE changes, not changes in other commands; and it neglected to revert the documentation changes.
* Add \ir command to psql.Robert Haas2011-07-06
| | | | | | | | | \ir is short for "include relative"; when used from a script, the supplied pathname will be interpreted relative to the input file, rather than to the current working directory. Gurjeet Singh, reviewed by Josh Kupershmidt, with substantial further cleanup by me.
* Restructure foreign data wrapper chapter so it has more than one section.Tom Lane2011-07-05
| | | | | | | | As noted by Laurenz Albe, our SGML tools deal rather oddly with chapters having just one <sect1>. Perhaps the tooling could be fixed, but really the design of this chapter's introduction is pretty bogus anyhow. Split it into a true introduction and a <sect1> about the FDW functions, so that it reads better and dodges the lack-of-a-chapter-TOC problem.
* Improve documentation about foreign data wrapper validator functions.Tom Lane2011-07-05
| | | | Modified version of a patch by Shigeru Hanada.
* Fix typo in sslmode documentationMagnus Hagander2011-07-05
| | | | Per bug #6089, noted by Sidney Cadot
* Small documentation tweaksPeter Eisentraut2011-07-05
|
* Set user_defined_types.data_type to nullPeter Eisentraut2011-07-04
| | | | | On re-reading the standard, this field is only used for distinct or reference types.
* Clarify that you need ActiveState perl 5.8 *or later* to build on Windows.Heikki Linnakangas2011-07-04
|
* Remove silent_mode. You get the same functionality with "pg_ctl -lHeikki Linnakangas2011-07-04
| | | | | | | | | postmaster.log", or nohup. There was a small issue with LINUX_OOM_ADJ and silent_mode, namely that with silent_mode the postmaster process incorrectly used the OOM settings meant for backend processes. We certainly could've fixed that directly, but since silent_mode was redundant anyway, we might as well just remove it.
* Reset ALTER TABLE lock levels to AccessExclusiveLock in all cases.Simon Riggs2011-07-04
| | | | | Locks on inheritance parent remain at lower level, as they were before. Remove entry from 9.1 release notes.
* Fix omissions in documentation of the pg_roles view.Tom Lane2011-07-03
| | | | | | | Somehow, column rolconfig got removed from the documentation of the pg_roles view in the 9.0 cycle, although the column is actually still there. In 9.1, we'd also forgotten to document the rolreplication column. Spotted by Sakamoto Masahiko.
* In the pg_upgrade docs, move 50432 port mention to the place where weBruce Momjian2011-07-01
| | | | talk about client access.
* Change pg_upgrade to use port 50432 by default to avoid unintendedBruce Momjian2011-07-01
| | | | | client connections during the upgrade. Also rename data/bin/port environment variables to being with 'PG'. Also no longer honor PGPORT.
* Enable CHECK constraints to be declared NOT VALIDAlvaro Herrera2011-06-30
| | | | | | | | | | | | | | | | | | | | | | | This means that they can initially be added to a large existing table without checking its initial contents, but new tuples must comply to them; a separate pass invoked by ALTER TABLE / VALIDATE can verify existing data and ensure it complies with the constraint, at which point it is marked validated and becomes a normal part of the table ecosystem. An non-validated CHECK constraint is ignored in the planner for constraint_exclusion purposes; when validated, cached plans are recomputed so that partitioning starts working right away. This patch also enables domains to have unvalidated CHECK constraints attached to them as well by way of ALTER DOMAIN / ADD CONSTRAINT / NOT VALID, which can later be validated with ALTER DOMAIN / VALIDATE CONSTRAINT. Thanks to Thom Brown, Dean Rasheed and Jaime Casanova for the various reviews, and Robert Hass for documentation wording improvement suggestions. This patch was sponsored by Enova Financial.
* Unify spelling of "canceled", "canceling", "cancellation"Peter Eisentraut2011-06-29
| | | | | We had previously (af26857a2775e7ceb0916155e931008c2116632f) established the U.S. spellings as standard.
* Implement the collation columns of various information schema viewsPeter Eisentraut2011-06-28
| | | | | | Fill in the collation columns of the views attributes, columns, domains, and element_types. Also update collation information in sql_implementation_info.
* Add composite-type attributes to information_schema.element_types viewPeter Eisentraut2011-06-28
|
* Mention that SSPI authentication can use GSSAPI on non-Windows systems.Robert Haas2011-06-27
| | | | As noted by Christian Ullrich.
* Documentation improvements for pg_locks with respect to SSI.Robert Haas2011-06-24
| | | | | | | Explain that querying pg_locks does not simultaneously lock both the normal lock manager and the predicate lock manager. Per discussion with Kevin Grittner.
* In pg_upgrade docs, clarify that link mode uses "hard" links.Bruce Momjian2011-06-23
| | | | Backpatch to 9.1 and 9.0.
* Add information schema views role_udt_grants, udt_privileges, user_defined_typesPeter Eisentraut2011-06-23
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-02 23:10:39 +0000