summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
AgeCommit message (Collapse)Author
2011-08-08Teach psql to display the comments on SQL/MED objects in verbose mode.Robert Haas
The relevant backslash commands already exist, so we're just adding an additional column. With this commit, all objects that have psql backslash commands and accept comments should now display those comments at least in verbose mode. Josh Kupershmidt, with doc additions by me.
2011-08-08Teach psql to display the comments on conversions and domains.Robert Haas
\dc and \dD now accept a "+" option, which will cause the comments to be displayed. Along the way, correct a few oversights in the previous commit in this area, 3b17efdfdd846c9bfad1637686e6f18198ea3df5 - namely, (1) when \dL+ is used, make description still be the last column, for consistency with what we've done elsewhere; and (2) document the difference between \dC and \dC+. Josh Kupershmidt, with a couple of doc changes by me.
2011-08-07Add "Compatibility" section to ALTER EXTENSION reference pagePeter Eisentraut
Almost all other pages have one; this one must have been forgotten.
2011-08-07Remove whitespace from end of linesPeter Eisentraut
2011-08-07Fix a whitespace issue with the man pagesPeter Eisentraut
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.
2011-08-05Allow per-column foreign data wrapper options.Robert Haas
Shigeru Hanada, with fairly minor editing by me.
2011-08-04Teach psql to display comments on languages and casts.Robert Haas
The output of \dL (list languages) is fairly narrow, so we just always display the comment. \dC (list casts) can get fairly wide, so we only display comments if the new \dC+ option is specified. Josh Kupershmidt
2011-07-27Fix typo.Robert Haas
Noted by Josh Kupershmidt.
2011-07-26Clarify which relkinds accept column comments.Robert Haas
Per discussion with Josh Kupershmidt.
2011-07-24Change EDITOR_LINENUMBER_SWITCH to an environment variablePeter Eisentraut
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.
2011-07-20Support SECURITY LABEL on databases, tablespaces, and roles.Robert Haas
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.
2011-07-20Improve sepgsql and SECURITY LABEL documentation.Robert Haas
KaiGai Kohei, based on feedback from Yeb Havinga, with some corrections by me.
2011-07-11Improve wording of documentation on default privileges.Andrew Dunstan
Per recent -hackers discussion.
2011-07-06Add \ir command to psql.Robert Haas
\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.
2011-06-30Enable CHECK constraints to be declared NOT VALIDAlvaro Herrera
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.
2011-06-29Unify spelling of "canceled", "canceling", "cancellation"Peter Eisentraut
We had previously (af26857a2775e7ceb0916155e931008c2116632f) established the U.S. spellings as standard.
2011-06-17Fix typo.Robert Haas
Per Josh Kupershmidt and Tom Lane.
2011-06-15Rework parsing of ConstraintAttributeSpec to improve NOT VALID handling.Tom Lane
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.
2011-06-14Document that psql's \d also works with composite typesPeter Eisentraut
This has always been true, it was just never documented.
2011-06-14Improve accuracy of ON_ERROR_STOP documentation.Robert Haas
Per a gripe from Tom Lane.
2011-06-13Expand warnings on locks acquired by CREATE INDEX CONCURRENTLYAlvaro Herrera
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
2011-06-13In ALTER EXTENSION docs, document left_type/right_type.Robert Haas
Noted by Daniele Varrazzo.
2011-06-12Corrections to ALTER FOREIGN TABLE documentation.Robert Haas
Shigeru Hanada, with a minor grammar correction.
2011-06-09Support silent mode for service registrations on win32Magnus Hagander
Using -s when registering a service will now suppress the application eventlog entries stating that the service is starting and started. MauMau
2011-06-08Reorder pg_ctl promote after pg_ctl statusPeter Eisentraut
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.
2011-06-03Sort COMMENT synopsis and add more examplesPeter Eisentraut
Josh Kupershmidt
2011-05-30Add pg_basebackup -z option for compression with default levelPeter Eisentraut
2011-05-29Allow pg_basebackup compressed tar output to stdoutPeter Eisentraut
2011-05-25Put options in some sensible orderPeter Eisentraut
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.
2011-05-22Put documentation of backslash commands back in alphabetical orderPeter Eisentraut
2011-05-19Rename pg_dump --no-security-label to --no-security-labelsPeter Eisentraut
Other similar options also use the plural form.
2011-05-19Spell checking and markup refinementPeter Eisentraut
2011-05-13More cleanup of FOREIGN TABLE permissions handling.Robert Haas
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.
2011-05-10Add some punctuationPeter Eisentraut
2011-05-10Put options in more alphabetical orderPeter Eisentraut
2011-05-06Fix typos in SECURITY LABEL documentation.Robert Haas
KaiGai Kohei
2011-05-02Small cleanup of spacing in verbatim DocBook elementsPeter Eisentraut
2011-04-28The arguments to pg_ctl kill are not optional - remove brackets in the docs.Heikki Linnakangas
Fujii Masao
2011-04-25Remove partial and undocumented GRANT .. FOREIGN TABLE support.Robert Haas
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.
2011-04-22Make a code-cleanup pass over the collations patch.Tom Lane
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().
2011-04-21Improve doc wording for SQL syntax of LIMIT/OFFSET.Bruce Momjian
2011-04-20Allow ALTER TYPE .. ADD ATTRIBUTE .. CASCADE to recurse to descendants.Robert Haas
Without this, adding an attribute to a typed table with an inheritance child fails, which is surprising. Noah Misch, with minor changes by me.
2011-04-20Allow ALTER TABLE name {OF type | NOT OF}.Robert Haas
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
2011-04-17Document COLLATE option in CREATE TYPE reference page.Tom Lane
Curiously, it was already documented in ALTER TYPE ADD ATTRIBUTE, but not here.
2011-04-13Add some useful cross-references to the CREATE EXTENSION reference page.Tom Lane
Per a suggestion from Josh Kupershmidt, though I modified his patch quite a lot.
2011-04-09Don't show unusable collations in psql's \dO command.Tom Lane
"Unusable" collations are those not matching the current database's encoding. The former behavior inconsistently showed such collations some of the time, depending on the details of the pattern argument.
2011-04-08Add an example of WITH (UPDATE RETURNING) INSERT to the INSERT ref page.Tom Lane
Per a discussion with Gavin Flower. This barely scratches the surface of potential WITH (something RETURNING) use cases, of course, but it's one of the simplest compelling examples I can think of.
2011-04-04Uppercase <!ENTITY> and <!DOCTYPE> tags in SGML sourceAlvaro Herrera
This improves compatibility with external toolchains, such as those used by some documentation translation tools. Gabriele Bartolini
2011-04-04Duplicate expansion of "direction" from FETCH's synopsis into MOVEAlvaro Herrera
2011-04-02Escape greater than and less than characters in docs.Heikki Linnakangas
Susanne Ebrecht and me
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-27 12:49:39 +0000