summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-09-23Document some more apparently-harmless error messages.Robert Haas
2011-09-23Add --{no-,}replication flags to createuser.Robert Haas
Fujii Masao, reviewed by Cédric Villemain, with some doc changes by me.
2011-09-23synchronous_commit is an enum not a boolean.Simon Riggs
Jaime Casanova
2011-09-22Update release notes for 9.1.1, 9.0.5, 8.4.9, 8.3.16, 8.2.22.Tom Lane
Man, we fixed a lotta bugs since April.
2011-09-16Add FORCE_NOT_NULL support to the file_fdw foreign data wrapper.Tom Lane
This is implemented as a per-column boolean option, rather than trying to match COPY's convention of a single option listing the column names. Shigeru Hanada, reviewed by KaiGai Kohei
2011-09-16Redesign the plancache mechanism for more flexibility and efficiency.Tom Lane
Rewrite plancache.c so that a "cached plan" (which is rather a misnomer at this point) can support generation of custom, parameter-value-dependent plans, and can make an intelligent choice between using custom plans and the traditional generic-plan approach. The specific choice algorithm implemented here can probably be improved in future, but this commit is all about getting the mechanism in place, not the policy. In addition, restructure the API to greatly reduce the amount of extraneous data copying needed. The main compromise needed to make that possible was to split the initial creation of a CachedPlanSource into two steps. It's worth noting in particular that SPI_saveplan is now deprecated in favor of SPI_keepplan, which accomplishes the same end result with zero data copying, and no need to then spend even more cycles throwing away the original SPIPlan. The risk of long-term memory leaks while manipulating SPIPlans has also been greatly reduced. Most of this improvement is based on use of the recently-added MemoryContextSetParent primitive.
2011-09-14In the manual section on primary_conninfo, recommend using a role withHeikki Linnakangas
REPLICATION privileges, not SUPERUSER. Fujii Masao
2011-09-10Remove double-quoting of table names in clusterdb. BACKWARD COMPABILITYBruce Momjian
BREAKAGE. Remove double-quoting of index/table names in reindexdb. BACKWARD COMPABILITY BREAKAGE. Document thate user/database names are preserved with double-quoting by command-line tools like vacuumdb.
2011-09-10Document that only user-defined columns are expanded by SELECT *.Bruce Momjian
2011-09-10Remove unnecessary MATCH FULL specification in example.Bruce Momjian
Reported by Grzegorz Szpetkowski.
2011-09-09Simplify handling of the timezone GUC by making initdb choose the default.Tom Lane
We were doing some amazingly complicated things in order to avoid running the very expensive identify_system_timezone() procedure during GUC initialization. But there is an obvious fix for that, which is to do it once during initdb and have initdb install the system-specific default into postgresql.conf, as it already does for most other GUC variables that need system-environment-dependent defaults. This means that the timezone (and log_timezone) settings no longer have any magic behavior in the server. Per discussion.
2011-09-09Move Timestamp/Interval typedefs and basic macros into datatype/timestamp.h.Tom Lane
As per my recent proposal, this refactors things so that these typedefs and macros are available in a header that can be included in frontend-ish code. I also changed various headers that were undesirably including utils/timestamp.h to include datatype/timestamp.h instead. Unsurprisingly, this showed that half the system was getting utils/timestamp.h by way of xlog.h. No actual code changes here, just header refactoring.
2011-09-08Fix typo and reword the sentence.Heikki Linnakangas
2011-09-08Buffering GiST index build algorithm.Heikki Linnakangas
When building a GiST index that doesn't fit in cache, buffers are attached to some internal nodes in the index. This speeds up the build by avoiding random I/O that would otherwise be needed to traverse all the way down the tree to the find right leaf page for tuple. Alexander Korotkov
2011-09-08One last round of copy-editing for the 9.1 release notes.Tom Lane
Also set the documented release date to 2011-09-12.
2011-09-07In pg_upgrade, disallow migration of 8.3 clusters using contrib/ltreeBruce Momjian
because its internal format was changed in 8.4. Backpatch to 9.0 and 9.1. Report by depesz, diagnosis by Tom.
2011-09-07Fix to_date() and to_timestamp() to handle year masks of length < 4 soBruce Momjian
they wrap toward year 2020, rather than the inconsistent behavior we had before.
2011-09-07Revert documentation patch about NEW/OLD and triggers.Bruce Momjian
Backpatch to 9.0 and 9.1. Patch from Josh Kupershmidt.
2011-09-06Properly document the existance of OLD/NEW trigger pl/pgsql triggerBruce Momjian
fields. Backpatch to 9.0 and 9.1. Report from Pavel Stehule, patch from Josh Kupershmidt
2011-09-06Fix spelling mistake in pgpass documentation change.Bruce Momjian
Per Peter.
2011-09-06Add documentation suggestion about adding a comment to the top ofBruce Momjian
pgpass. Backpatch to 9.1.
2011-09-06Fix plpgsql "PERFORM" markup.Bruce Momjian
Backpatch to 9.0 and 9.1.
2011-09-06Document PERFORM limitation when using WITH queries.Bruce Momjian
Backpatch to 9.0 and 9.1. Report from depstein@alliedtesting.com.
2011-09-06Add an "incompatibility" entry to 9.1 release notes about CREATE EXTENSION.Tom Lane
We've now seen more than one gripe from somebody who didn't get the memo about how to install contrib modules in 9.1. Try to make it a little more prominent that you aren't supposed to call the scripts directly anymore.
2011-09-06Update type-conversion documentation for long-ago changes.Tom Lane
This example wasn't updated when we changed the behavior of bpcharlen() in 8.0, nor when we changed the number of parameters taken by the bpchar() cast function in 7.3. Per report from lsliang.
2011-09-06Properly document semphore requirements by accounting for workerBruce Momjian
processes. Backpatch to 9.1 and 9.0. Submitted by Anton Yuzhaninov, confirmed by Robert Haas
2011-09-05Add documentation link to strftime supported options.Bruce Momjian
2011-09-05Add mention that UTC really means UT1.Bruce Momjian
Backpatch to 9.1.
2011-09-05Document that contrib/pgtrgm only processes ASCII alphanumericBruce Momjian
characters. Backpatch to 9.0 and 9.1.
2011-09-01Userspace access vector cache for contrib/sepgsql.Robert Haas
KaiGai Kohei
2011-08-31The replication status values in pg_stat_replication was changed toHeikki Linnakangas
lowercase earlier, but documentation was not updated. Update the docs. Fujii Masao
2011-08-30Some markup cleanup to deconfuse the find_gt_lt toolPeter Eisentraut
Josh Kupershmidt
2011-08-30Repair brain fade in previous commit, per Josh Kupershmidt.Robert Haas
2011-08-30Add --if-exists option to dropdb and dropuser.Robert Haas
Josh Kupershmidt, with some further editing by me.
2011-08-27Document minimum required version of DocBook XSL stylesheetsPeter Eisentraut
2011-08-27Implement the information schema with_hierarchy columnPeter Eisentraut
In PostgreSQL, this is included in the SELECT privilege, so show YES or NO depending on whether SELECT is granted.
2011-08-27Spelling improvementPeter Eisentraut
2011-08-26Clean up weird corner cases in lexing of psql meta-command arguments.Tom Lane
These changes allow backtick command evaluation and psql variable interpolation to happen on substrings of a single meta-command argument. Formerly, no such evaluations happened at all if the backtick or colon wasn't the first character of the argument, and we considered an argument completed as soon as we'd processed one backtick, variable reference, or quoted substring. A string like 'FOO'BAR was thus taken as two arguments not one, not exactly what one would expect. In the new coding, an argument is considered terminated only by unquoted whitespace or backslash. Also, clean up a bunch of omissions, infelicities and outright errors in the psql documentation of variables and metacommand argument syntax.
2011-08-26Support non-ASCII letters in psql variable names.Tom Lane
As in the backend, the implementation actually accepts any non-ASCII character, but we only document that you can use letters.
2011-08-25Adjust CREATE DOMAIN example for standard_conforming_strings=on.Robert Haas
Noted by Hitoshi Harada.
2011-08-24Fix pgxs.mk to always add --dbname=$(CONTRIB_TESTDB) to REGRESS_OPTS.Tom Lane
The previous coding resulted in contrib modules unintentionally overriding the use of CONTRIB_TESTDB. There seems no particularly good reason to allow that (after all, the makefile can set CONTRIB_TESTDB if that's really what it intends). In passing, document REGRESS_OPTS where the other pgxs.mk options are documented. Back-patch to 9.1 --- in prior versions, there were no cases of contrib modules setting REGRESS_OPTS without including the --dbname switch, so while the coding was fragile there was no actual bug.
2011-08-23Add recovery.conf to the index in the user manual.Heikki Linnakangas
Fujii Masao
2011-08-17Update 9.1 release notes to reflect commits through today.Tom Lane
Also do another pass of copy-editing.
2011-08-17Adjust wording now that estimated size can increaseMagnus Hagander
Per comment form Fujii Masao.
2011-08-17MacOS -> Mac OSPeter Eisentraut
Josh Kupershmidt
2011-08-14Fix typoPeter Eisentraut
2011-08-11Add major features list and introductory text for 9.1 release notes.Bruce Momjian
Backpatch to 9.1, obviously.
2011-08-11Display both per-table and per-column FDW options in psql's \d output.Robert Haas
Along the way, rename "Options" to "FDW Options" in various places for consistency and clarity. Shigeru Hanada
2011-08-11Change psql's \dd command to do something more useful.Robert Haas
Instead of displaying comments on an arbitrary subset of the object types which support them, make \dd display comments on exactly those object types which don't have their own backlash commands. We now regard the display of comments as properly the job of the relevant backslash command (though many of them do so only in verbose mode) rather than something that \dd should be responsible for. However, a handful of object types have no backlash command, so make \dd give information about those. Josh Kupershmidt
2011-08-10Remove wal_sender_delay GUC, because it's no longer useful.Tom Lane
The latch infrastructure is now capable of detecting all cases where the walsender loop needs to wake up, so there is no reason to have an arbitrary timeout. Also, modify the walsender loop logic to follow the standard pattern of ResetLatch, test for work to do, WaitLatch. The previous coding was both hard to follow and buggy: it would sometimes busy-loop despite having nothing available to do, eg between receipt of a signal and the next time it was caught up with new WAL, and it also had interesting choices like deciding to update to WALSNDSTATE_STREAMING on the strength of information known to be obsolete.
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-30 17:39:50 +0000