summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-06-17Don't use "cp -i" in the example WAL archive_command.Tom Lane
This is a dangerous example to provide because on machines with GNU cp, it will silently do the wrong thing and risk archive corruption. Worse, during the 9.0 cycle somebody "improved" the discussion by removing the warning that used to be there about that, and instead leaving the impression that the command would work as desired on most Unixen. It doesn't. Try to rectify the damage by providing an example that is safe most everywhere, and then noting that you can try cp -i if you want but you'd better test that. In back-patching this to all supported branches, I also added an example command for Windows, which wasn't provided before 9.0.
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-14In pg_upgrade, document that link mode has to have data directories onBruce Momjian
the same file system, and that authentication should lock out normal users. Per suggestsion from #postgresql irc channel. Backpatch to 9.1.
2011-06-14Fix grammatical mistake introduced by previous commitAlvaro Herrera
Per note from Tom
2011-06-14Mention DROP TABLE as well as ALTER TABLE NO INHERITAlvaro Herrera
... when talking about how good they are in replacement of bulk DELETE in partitioned setups. The original wording was a bit confusing. Per an observation from David Wheeler.
2011-06-14Improve accuracy of ON_ERROR_STOP documentation.Robert Haas
Per a gripe from Tom Lane.
2011-06-13Document that bits to the right of the CIDR mask "should" be zero, notBruce Momjian
"must".
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-13Remove parentheses from mention of current_schemas function.Robert Haas
This is more consistent with what we do elsewhere, and hopefully avoids creating the perception that current_schemas takes no arguments. As suggested by Brendan Jurd
2011-06-13Clarify that NATURAL without matching columns is like CROSS JOIN.Robert Haas
As suggested by Grzegorz Szpetkowski.
2011-06-13Add doc cross-reference to search_path discussion of current_schemas().Robert Haas
Brendan Jurd
2011-06-13Document GUC context for synchronous_standby_names/hot_standby_feedback.Robert Haas
Fujii Masao
2011-06-13In ALTER EXTENSION docs, document left_type/right_type.Robert Haas
Noted by Daniele Varrazzo.
2011-06-13Markup fix.Robert Haas
Fujii Masao
2011-06-13More foreign table documentation improvements.Robert Haas
Shigeru Hanada, with some additional wordsmithing by me
2011-06-12Corrections to ALTER FOREIGN TABLE documentation.Robert Haas
Shigeru Hanada, with a minor grammar correction.
2011-06-09Ecpg doc cleanups, as reported by Marc Cousin.Bruce Momjian
2011-06-09Update 9.1 release notes to reflect commits through today.Tom Lane
Also do some desultory copy-editing on the notes.
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-09Fix documentation of information_schema.element_typesPeter Eisentraut
The documentation of the columns collection_type_identifier and dtd_identifier was wrong. This effectively reverts commits 8e1ccad51901e83916dae297cd9afa450957a36c and 57352df66d3a0885899d39c04c067e63c7c0ba30 and updates the name array_type_identifier (the name in SQL:1999) to collection_type_identifier. closes bug #5926
2011-06-08Make citext's equality and hashing functions collation-insensitive.Tom Lane
This is an ugly hack to get around the fact that significant parts of the core backend assume they don't need to worry about passing collation to equality and hashing functions. That's true for the core string datatypes, but citext should ideally have equality behavior that depends on the specified collation's LC_CTYPE. However, there's no chance of fixing the core before 9.2, so we'll have to live with this compromise arrangement for now. Per bug #6053 from Regina Obe. The code changes in this commit should be reverted in full once the core code is up to speed, but be careful about reverting the docs changes: I fixed a number of obsolete statements while at it.
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-04Fix documentation reference to "above" examplePeter Eisentraut
found by Thom Brown
2011-06-04More ECPG documentation fixesPeter Eisentraut
Marc Cousin
2011-06-04ECPG documentation fixPeter Eisentraut
Marc Cousin, Satoshi Nagayasu
2011-06-03Truncate id to <=44 charactersPeter Eisentraut
This is the original DocBook SGML limit, but apparently most installations have changed it or ignore it, which is why few people have run into this problem. pointed out by Brendan Jurd
2011-06-02Use proper SGML doc entities rather than angle-brackets.Bruce Momjian
Marco Nenciarini
2011-06-03Sort COMMENT synopsis and add more examplesPeter Eisentraut
Josh Kupershmidt
2011-06-01Some copy editing of the release notesPeter Eisentraut
2011-05-31Protect GIST logic that assumes penalty values can't be negative.Tom Lane
Apparently sane-looking penalty code might return small negative values, for example because of roundoff error. This will confuse places like gistchoose(). Prevent problems by clamping negative penalty values to zero. (Just to be really sure, I also made it force NaNs to zero.) Back-patch to all supported branches. Alexander Korotkov
2011-05-31Use entities to encode non-ASCII characters in SGML documentationPeter Eisentraut
This has already been the case for the most part; just some cases had slipped through.
2011-05-31Replace use of credential control messages with getsockopt(LOCAL_PEERCRED).Tom Lane
It turns out the reason we hadn't found out about the portability issues with our credential-control-message code is that almost no modern platforms use that code at all; the ones that used to need it now offer getpeereid(), which we choose first. The last holdout was NetBSD, and they added getpeereid() as of 5.0. So far as I can tell, the only live platform on which that code was being exercised was Debian/kFreeBSD, ie, FreeBSD kernel with Linux userland --- since glibc doesn't provide getpeereid(), we fell back to the control message code. However, the FreeBSD kernel provides a LOCAL_PEERCRED socket parameter that's functionally equivalent to Linux's SO_PEERCRED. That is both much simpler to use than control messages, and superior because it doesn't require receiving a message from the other end at just the right time. Therefore, add code to use LOCAL_PEERCRED when necessary, and rip out all the credential-control-message code in the backend. (libpq still has such code so that it can still talk to pre-9.1 servers ... but eventually we can get rid of it there too.) Clean up related autoconf probes, too. This means that libpq's requirepeer parameter now works on exactly the same platforms where the backend supports peer authentication, so adjust the documentation accordingly.
2011-05-30Don't recommend upgrading to latest available Windows SDKMagnus Hagander
We only support up to version 7.0, so don't recommend upgrading past it. The rest of the documentation around this was already updated, but one spot was missed.
2011-05-30Add pg_basebackup -z option for compression with default levelPeter Eisentraut
2011-05-29Correct description of log_connections and log_disconnectionsPeter Eisentraut
The previous claim when these parameters could be changed was incorrect. Fujii Masao
2011-05-29Allow pg_basebackup compressed tar output to stdoutPeter Eisentraut
2011-05-28Drop "meaning" column from error code tablePeter Eisentraut
This is currently the same as the condition name, so it doesn't add any value, only clutter.
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 lists in sensible orderPeter Eisentraut
2011-05-22Put documentation of backslash commands back in alphabetical orderPeter Eisentraut
2011-05-22Clarify the documentation of the --with-ossp-uuid optionPeter Eisentraut
2011-05-19Rename pg_dump --no-security-label to --no-security-labelsPeter Eisentraut
Other similar options also use the plural form.
2011-05-19Remove obsolete commentPeter Eisentraut
2011-05-19Spell checking and markup refinementPeter Eisentraut
2011-05-19/contrib/foo -> contrib/fooPeter Eisentraut
Since contrib is a relative directory specification, a leading slash is inappropriate.
2011-05-16Remove redundant privilege doc sentences.Bruce Momjian
2011-05-16Allow pg_upgrade to honor libpq environment variables. Add 'local'Bruce Momjian
checks for PGHOST and PGHOSTADDR.
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.
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-25 08:50:07 +0000