aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add a bit of markupPeter Eisentraut2011-06-23
|
* Add smallserial pseudotype.Robert Haas2011-06-21
| | | | | | | This is just like serial and bigserial, except it generates an int2 column rather than int4 or int8. Mike Pultz, reviewed by Brar Piening and Josh Kupershmidt
* Make deadlock_timeout PGC_SUSET rather than PGC_SIGHUP.Robert Haas2011-06-21
| | | | | | | | | | | | | | | | | This allows deadlock_timeout to be reduced for transactions that are particularly likely to be involved in a deadlock, thus detecting it more quickly. It is also potentially useful as a poor-man's deadlock priority mechanism: a transaction with a high deadlock_timeout is less likely to be chosen as the victim than one with a low deadlock_timeout. Since that could be used to game the system, we make this PGC_SUSET rather than PGC_USERSET. At some point, it might be worth thinking about a more explicit priority mechanism, since using this is far from fool-proof. But let's see whether there's enough use case to justify the additional work before we go down that route. Noah Misch, reviewed by Shigeru Hanada
* Add notion of a "transform function" that can simplify function calls.Robert Haas2011-06-21
| | | | | | | | | | Initially, we use this only to eliminate calls to the varchar() function in cases where the length is not being reduced and, therefore, the function call is equivalent to a RelabelType operation. The most significant effect of this is that we can avoid a table rewrite when changing a varchar(X) column to a varchar(Y) column, where Y > X. Noah Misch, reviewed by me and Alexey Klyukin
* Performance tuning advice for SSI.Robert Haas2011-06-21
| | | | Kevin Grittner, with additional wordsmithing by me.
* Fix missed use of "cp -i" in an example, per Fujii Masao.Tom Lane2011-06-20
| | | | Also be more careful about markup: use & not just &.
* Produce HISTORY file consistently as ASCIIPeter Eisentraut2011-06-19
| | | | | | | | The release notes may contain non-ASCII characters (for contributor names), which lynx converts to the encoding determined by the current locale. The get output that is deterministic and easily readable by everyone, we make lynx produce LATIN1 and then convert that to ASCII with transliteration for the non-ASCII characters.
* Capitalization fixesPeter Eisentraut2011-06-19
|
* Don't use "cp -i" in the example WAL archive_command.Tom Lane2011-06-17
| | | | | | | | | | | | | | 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.
* 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.
* In pg_upgrade, document that link mode has to have data directories onBruce Momjian2011-06-14
| | | | | | | | | the same file system, and that authentication should lock out normal users. Per suggestsion from #postgresql irc channel. Backpatch to 9.1.
* Fix grammatical mistake introduced by previous commitAlvaro Herrera2011-06-14
| | | | Per note from Tom
* Mention DROP TABLE as well as ALTER TABLE NO INHERITAlvaro Herrera2011-06-14
| | | | | | | | | ... 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.
* Improve accuracy of ON_ERROR_STOP documentation.Robert Haas2011-06-14
| | | | Per a gripe from Tom Lane.
* Document that bits to the right of the CIDR mask "should" be zero, notBruce Momjian2011-06-13
| | | | "must".
* 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
* Remove parentheses from mention of current_schemas function.Robert Haas2011-06-13
| | | | | | | 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
* Clarify that NATURAL without matching columns is like CROSS JOIN.Robert Haas2011-06-13
| | | | As suggested by Grzegorz Szpetkowski.
* Add doc cross-reference to search_path discussion of current_schemas().Robert Haas2011-06-13
| | | | Brendan Jurd
* Document GUC context for synchronous_standby_names/hot_standby_feedback.Robert Haas2011-06-13
| | | | Fujii Masao
* In ALTER EXTENSION docs, document left_type/right_type.Robert Haas2011-06-13
| | | | Noted by Daniele Varrazzo.
* Markup fix.Robert Haas2011-06-13
| | | | Fujii Masao
* More foreign table documentation improvements.Robert Haas2011-06-13
| | | | Shigeru Hanada, with some additional wordsmithing by me
* Corrections to ALTER FOREIGN TABLE documentation.Robert Haas2011-06-12
| | | | Shigeru Hanada, with a minor grammar correction.
* Ecpg doc cleanups, as reported by Marc Cousin.Bruce Momjian2011-06-09
|
* Update 9.1 release notes to reflect commits through today.Tom Lane2011-06-09
| | | | Also do some desultory copy-editing on the notes.
* 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
* Fix documentation of information_schema.element_typesPeter Eisentraut2011-06-09
| | | | | | | | | | | 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
* Make citext's equality and hashing functions collation-insensitive.Tom Lane2011-06-08
| | | | | | | | | | | | | | 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.
* 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.
* Fix documentation reference to "above" examplePeter Eisentraut2011-06-04
| | | | found by Thom Brown
* More ECPG documentation fixesPeter Eisentraut2011-06-04
| | | | Marc Cousin
* ECPG documentation fixPeter Eisentraut2011-06-04
| | | | Marc Cousin, Satoshi Nagayasu
* Truncate id to <=44 charactersPeter Eisentraut2011-06-03
| | | | | | | | 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
* Use proper SGML doc entities rather than angle-brackets.Bruce Momjian2011-06-02
| | | | Marco Nenciarini
* Sort COMMENT synopsis and add more examplesPeter Eisentraut2011-06-03
| | | | Josh Kupershmidt
* Some copy editing of the release notesPeter Eisentraut2011-06-01
|
* Protect GIST logic that assumes penalty values can't be negative.Tom Lane2011-05-31
| | | | | | | | | | 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
* Use entities to encode non-ASCII characters in SGML documentationPeter Eisentraut2011-05-31
| | | | | This has already been the case for the most part; just some cases had slipped through.
* Replace use of credential control messages with getsockopt(LOCAL_PEERCRED).Tom Lane2011-05-31
| | | | | | | | | | | | | | | | | | | | | | | | 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.
* Don't recommend upgrading to latest available Windows SDKMagnus Hagander2011-05-30
| | | | | | 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.
* Add pg_basebackup -z option for compression with default levelPeter Eisentraut2011-05-30
|
* Correct description of log_connections and log_disconnectionsPeter Eisentraut2011-05-29
| | | | | | | The previous claim when these parameters could be changed was incorrect. Fujii Masao
* Allow pg_basebackup compressed tar output to stdoutPeter Eisentraut2011-05-29
|
* Drop "meaning" column from error code tablePeter Eisentraut2011-05-28
| | | | | This is currently the same as the condition name, so it doesn't add any value, only clutter.
* 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 lists in sensible orderPeter Eisentraut2011-05-22
|
* Put documentation of backslash commands back in alphabetical orderPeter Eisentraut2011-05-22
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-03 13:50:52 +0000