aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
Commit message (Collapse)AuthorAge
* Provide adequate documentation of the "table_name *" notation.Tom Lane2012-09-17
| | | | | | | | | Somewhere along the line, somebody decided to remove all trace of this notation from the documentation text. It was still in the command syntax synopses, or at least some of them, but with no indication what it meant. This will not do, as evidenced by the confusion apparent in bug #7543; even if the notation is now unnecessary, people will find it in legacy SQL code and need to know what it does.
* Reword documentation for concurrent index rebuilds to be clearer.Bruce Momjian2012-08-04
| | | | Backpatch to 9.1 and 9.2.
* Document that, for psql -c, only the result of the last command isBruce Momjian2012-08-03
| | | | | | returned, per report from Aleksey Tsalolikhin Backpatch to 9.2 and 9.1.
* Remove tabs in SGML filesBruce Momjian2012-03-12
|
* Add description for --no-locale and --text-search-config.Tatsuo Ishii2012-03-11
|
* Require execute permission on the trigger function for CREATE TRIGGER.Tom Lane2012-02-23
| | | | | | | | | | | | | | | | | This check was overlooked when we added function execute permissions to the system years ago. For an ordinary trigger function it's not a big deal, since trigger functions execute with the permissions of the table owner, so they couldn't do anything the user issuing the CREATE TRIGGER couldn't have done anyway. However, if a trigger function is SECURITY DEFINER, that is not the case. The lack of checking would allow another user to install it on his own table and then invoke it with, essentially, forged input data; which the trigger function is unlikely to realize, so it might do something undesirable, for instance insert false entries in an audit log table. Reported by Dinesh Kumar, patch by Robert Haas Security: CVE-2012-0866
* Update statement about sorting of character-string data.Tom Lane2012-01-28
| | | | | The sort order is no longer fixed at database creation time, but can be controlled via COLLATE. Noted by Thomas Kellerer.
* Clarify documentation about SQL:2008 variant of LIMIT/OFFSET syntax.Tom Lane2011-12-01
| | | | | The point that you need parentheses for non-constant expressions apparently needs to be brought out a bit more clearly, per bug #6315.
* Clarify that ORDER BY/FOR UPDATE can't malfunction at higher iso levels.Robert Haas2011-10-28
| | | | Kevin Grittner
* Fix typoMagnus Hagander2011-10-25
|
* Improve documentation of psql's \q command.Tom Lane2011-10-12
| | | | | | The documentation neglected to explain its behavior in a script file (it only ends execution of the script, not psql as a whole), and failed to mention the long form \quit either.
* Spelling improvementPeter Eisentraut2011-08-27
|
* Adjust CREATE DOMAIN example for standard_conforming_strings=on.Robert Haas2011-08-25
| | | | Noted by Hitoshi Harada.
* Adjust wording now that estimated size can increaseMagnus Hagander2011-08-17
| | | | Per comment form Fujii Masao.
* Add "Compatibility" section to ALTER EXTENSION reference pagePeter Eisentraut2011-08-07
| | | | Almost all other pages have one; this one must have been forgotten.
* Remove whitespace from end of linesPeter Eisentraut2011-08-07
|
* Fix a whitespace issue with the man pagesPeter Eisentraut2011-08-07
| | | | | | | | | | | | | | | | | | | | | There is what may actually be a mistake in our markup. The problem is in a situation like <para> <command>FOO</command> is ... there is strictly speaking a line break before "FOO". In the HTML output, this does not appear to be a problem, but in the man page output, this shows up, so you get double blank lines at odd places. So far, we have attempted to work around this with an XSL hack, but that causes other problems, such as creating run-ins in places like <acronym>SQL</acronym> <command>COPY</command> So fix the problem properly by removing the extra whitespace. I only fixed the problems that affect the man page output, not all the places.
* Fix typo.Robert Haas2011-07-27
| | | | Noted by Josh Kupershmidt.
* Clarify which relkinds accept column comments.Robert Haas2011-07-26
| | | | Per discussion with Josh Kupershmidt.
* Change EDITOR_LINENUMBER_SWITCH to an environment variablePeter Eisentraut2011-07-24
| | | | | | | | | | | Also change "switch" to "arg" because "switch" is a bit of a sloppy term. So the environment variable is called PSQL_EDITOR_LINENUMBER_ARG. Set "+" as hardcoded default value on Unix (since "vi" is the hardcoded default editor), so many users won't have to configure this at all. Move the documentation around a bit to centralize the editor configuration under environment variables, rather than repeating bits of it under every backslash command that invokes an editor.
* Improve sepgsql and SECURITY LABEL documentation.Robert Haas2011-07-20
| | | | | KaiGai Kohei, based on feedback from Yeb Havinga, with some corrections by me.
* Unify spelling of "canceled", "canceling", "cancellation"Peter Eisentraut2011-07-02
| | | | | We had previously (af26857a2775e7ceb0916155e931008c2116632f) established the U.S. spellings as standard.
* Fix typo.Robert Haas2011-06-17
| | | | Per Josh Kupershmidt and Tom Lane.
* Rework parsing of ConstraintAttributeSpec to improve NOT VALID handling.Tom Lane2011-06-15
| | | | | | | | | | | The initial commit of the ALTER TABLE ADD FOREIGN KEY NOT VALID feature failed to support labeling such constraints as deferrable. The best fix for this seems to be to fold NOT VALID into ConstraintAttributeSpec. That's a bit more general than the documented syntax, but it allows better-targeted syntax error messages. In addition, do some mostly-but-not-entirely-cosmetic code review for the whole NOT VALID patch.
* Document that psql's \d also works with composite typesPeter Eisentraut2011-06-14
| | | | This has always been true, it was just never documented.
* Improve accuracy of ON_ERROR_STOP documentation.Robert Haas2011-06-14
| | | | Per a gripe from Tom Lane.
* Expand warnings on locks acquired by CREATE INDEX CONCURRENTLYAlvaro Herrera2011-06-13
| | | | | | | | | The previous wording wasn't explicit enough, which could misled readers into thinking that the locks acquired are more restricted in nature than they really are. The resulting optimism can be damaging to morale when confronted with reality, as has been observed in the field. Greg Smith
* In ALTER EXTENSION docs, document left_type/right_type.Robert Haas2011-06-13
| | | | Noted by Daniele Varrazzo.
* Corrections to ALTER FOREIGN TABLE documentation.Robert Haas2011-06-12
| | | | Shigeru Hanada, with a minor grammar correction.
* Support silent mode for service registrations on win32Magnus Hagander2011-06-09
| | | | | | | | Using -s when registering a service will now suppress the application eventlog entries stating that the service is starting and started. MauMau
* Reorder pg_ctl promote after pg_ctl statusPeter Eisentraut2011-06-08
| | | | | | | | | | | | Since start/stop/restart/reload/status is a kind of standard command set, it seems odd to insert the special-purpose "promote" in between the closely related "restart" and "reload". So put it after "status" in code and documentation. Put the documentation of the -U option in some sensible place. Rewrite the synopsis sentence in help and documentation to make it less of a growing mouthful.
* Sort COMMENT synopsis and add more examplesPeter Eisentraut2011-06-03
| | | | Josh Kupershmidt
* Add pg_basebackup -z option for compression with default levelPeter Eisentraut2011-05-30
|
* Allow pg_basebackup compressed tar output to stdoutPeter Eisentraut2011-05-29
|
* Put options in some sensible orderPeter Eisentraut2011-05-25
| | | | | | | For the --help output and reference pages of pg_dump, pg_dumpall, pg_restore, put the options in some consistent, mostly alphabetical, and consistent order, rather than newest option last or something like that.
* Put documentation of backslash commands back in alphabetical orderPeter Eisentraut2011-05-22
|
* Rename pg_dump --no-security-label to --no-security-labelsPeter Eisentraut2011-05-19
| | | | Other similar options also use the plural form.
* Spell checking and markup refinementPeter Eisentraut2011-05-19
|
* More cleanup of FOREIGN TABLE permissions handling.Robert Haas2011-05-13
| | | | | | | | | This commit fixes psql, pg_dump, and the information schema to be consistent with the backend changes which I made as part of commit be90032e0d1cf473bdd99aee94218218f59f29f1, and also includes a related documentation tweak. Shigeru Hanada, with slight adjustment.
* Add some punctuationPeter Eisentraut2011-05-10
|
* Put options in more alphabetical orderPeter Eisentraut2011-05-10
|
* Fix typos in SECURITY LABEL documentation.Robert Haas2011-05-06
| | | | KaiGai Kohei
* Small cleanup of spacing in verbatim DocBook elementsPeter Eisentraut2011-05-02
|
* The arguments to pg_ctl kill are not optional - remove brackets in the docs.Heikki Linnakangas2011-04-28
| | | | Fujii Masao
* Remove partial and undocumented GRANT .. FOREIGN TABLE support.Robert Haas2011-04-25
| | | | | | | | | | | Instead, foreign tables are treated just like views: permissions can be granted using GRANT privilege ON [TABLE] foreign_table_name TO role, and revoked similarly. GRANT/REVOKE .. FOREIGN TABLE is no longer supported, just as we don't support GRANT/REVOKE .. VIEW. The set of accepted permissions for foreign tables is now identical to the set for regular tables, and views. Per report from Thom Brown, and subsequent discussion.
* Make a code-cleanup pass over the collations patch.Tom Lane2011-04-22
| | | | | | | This patch is almost entirely cosmetic --- mostly cleaning up a lot of neglected comments, and fixing code layout problems in places where the patch made lines too long and then pgindent did weird things with that. I did find a bug-of-omission in equalTupleDescs().
* Improve doc wording for SQL syntax of LIMIT/OFFSET.Bruce Momjian2011-04-21
|
* Allow ALTER TYPE .. ADD ATTRIBUTE .. CASCADE to recurse to descendants.Robert Haas2011-04-20
| | | | | | | Without this, adding an attribute to a typed table with an inheritance child fails, which is surprising. Noah Misch, with minor changes by me.
* Allow ALTER TABLE name {OF type | NOT OF}.Robert Haas2011-04-20
| | | | | | | | | | | This syntax allows a standalone table to be made into a typed table, or a typed table to be made standalone. This is possibly a mildly useful feature in its own right, but the real motivation for this change is that we need it to make pg_upgrade work with typed tables. This doesn't actually fix that problem, but it's necessary infrastructure. Noah Misch
* Document COLLATE option in CREATE TYPE reference page.Tom Lane2011-04-17
| | | | | Curiously, it was already documented in ALTER TYPE ADD ATTRIBUTE, but not here.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-04 13:15:49 +0000