summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
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-25Normalize whitespace in the arguments of <indexterm>Peter Eisentraut
Strip leading and trailing whitespace and replace interior whitespace by a single space. This avoids problems with the index generator producing duplicate index entries for terms that differ only in whitespace. Commit dca30da3433c40b5f92f1704c496cda052decef9 actually fixed all the indexterm elements that would cause this problem at the moment, but in case it sneaks in again, we're set.
2011-04-23Adjust comments about collate.linux.utf8 regression test.Tom Lane
This test should now work in any database with UTF8 encoding, regardless of the database's default locale. The former restriction was really "doesn't work if default locale is C", and that was because of not handling mbstowcs/wcstombs correctly.
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-17Support a COLLATE clause in plpgsql variable declarations.Tom Lane
This allows the usual rules for assigning a collation to a local variable to be overridden. Per discussion, it seems appropriate to support this rather than forcing all local variables to have the argument-derived collation.
2011-04-15Note that Bison on GnuWin32 has trouble with paths with spacesMagnus Hagander
Peter Eisentraut
2011-04-15Specify which versions of the Platform SDK are supportedMagnus Hagander
Anything including Visual Studio 2010 compilers is not yet supported for building on Windows.
2011-04-15Rename pg_regress option --multibyte to --encodingPeter Eisentraut
Also refactor things a little bit so that the same methods for setting test locale and encoding can be used everywhere.
2011-04-14Update release notes for releases 9.0.4, 8.4.8, 8.3.15, and 8.2.21.Tom Lane
2011-04-14Advise Debian/Ubuntu users to use openjade1.3.Robert Haas
The latest openjade packages for Ubuntu 10.10 seg fault when building our documentation. Josh Berkus
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-10Teach regular expression operators to honor collations.Tom Lane
This involves getting the character classification and case-folding functions in the regex library to use the collations infrastructure. Most of this work had been done already in connection with the upper/lower and LIKE logic, so it was a simple matter of transposition. While at it, split out these functions into a separate source file regc_pg_locale.c, so that they can be correctly labeled with the Postgres project's license rather than the Scriptics license. These functions are 100% Postgres-written code whereas what remains in regc_locale.c is still mostly not ours, so lumping them both under the same copyright notice was getting more and more misleading.
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-08Avoid extra whitespace in the arguments of <indexterm>.Tom Lane
As noted by Thom Brown, this confuses the DocBook index processor; it fails to merge entries that differ only in whitespace, and sorts them unexpectedly as well. Seems like a toolchain bug, but I'm not going to hold my breath waiting for a fix. Note: easiest way to find these is to look for double spaces in HTML.index.
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-06Update key words table for 9.1Peter Eisentraut
2011-04-05Change "Id" to "id" in some SGML tagsAlvaro Herrera
Gabriele Bartolini
2011-04-05Typo fixes.Robert Haas
Erik Rijkers
2011-04-05Add casts from int4 and int8 to numeric.Robert Haas
Joey Adams, per gripe from Ramanujam. Review by myself and Tom Lane.
2011-04-04Centralise release note items related to recovery and replicationSimon Riggs
2011-04-04Update comments and credit doc proofreadersSimon Riggs
2011-04-04Merge synchronous_replication setting into synchronous_commit.Robert Haas
This means one less thing to configure when setting up synchronous replication, and also avoids some ambiguity around what the behavior should be when the settings of these variables conflict. Fujii Masao, with additional hacking by me.
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-03Improve documentation on the range of the numeric data type.Robert Haas
Gianni Ciolli, reviewed by Noah Misch
2011-04-03Remove mention of using "man" from the tutorial.Robert Haas
This isn't applicable on Windows, and the internal link to the psql documentation should be more than sufficient. Susanne Ebrecht
2011-04-02Escape greater than and less than characters in docs.Heikki Linnakangas
Susanne Ebrecht and me
2011-04-01Support comments on FOREIGN DATA WRAPPER and SERVER objects.Robert Haas
This mostly involves making it work with the objectaddress.c framework, which does most of the heavy lifting. In that vein, change GetForeignDataWrapperOidByName to get_foreign_data_wrapper_oid and GetForeignServerOidByName to get_foreign_server_oid, to match the pattern we use for other object types. Robert Haas and Shigeru Hanada
2011-03-31Reword the phrase on zero replication_timeout in the docs.Heikki Linnakangas
2011-03-30Automatically terminate replication connections that are idle for moreHeikki Linnakangas
than replication_timeout (a new GUC) milliseconds. The TCP timeout is often too long, you want the master to notice a dead connection much sooner. People complained about that in 9.0 too, but with synchronous replication it's even more important to notice dead connections promptly. Fujii Masao and Heikki Linnakangas
2011-03-28Add maintainer-check targetPeter Eisentraut
This can do various source code checks that are not appropriate for either the build or the regression tests. Currently: duplicate_oids, SGML syntax and tabs check, NLS syntax check.
2011-03-28Add 9.1 release note link for synchronous replication.Bruce Momjian
We already had links to the GUC variables that control it.
2011-03-28Mark up release notes using <link>.REL9_1_ALPHA5Robert Haas
Unlike <xref>, this actually works.
2011-03-28Get rid of links that don't work when building HISTORY.Tom Lane
2011-03-27Typo fix in SSI docs.Robert Haas
Kevin Grittner
2011-03-27Correct "characters" to "bytes" in createdb docs.Robert Haas
Susanne Ebrecht
2011-03-26Remove disclaimer stating that fsync=off slows down sync rep.Robert Haas
The underlying problem that caused this phenomenon was fixed by commit 92f4786fa9b730fd12cbfe973eb96addc6e98924.
2011-03-26Update release notes for latest commits.Robert Haas
In addition, correct the entry for pg_object_description, and some other minor cleanup.
2011-03-25Document collation handling in SQL and plpgsql functions.Tom Lane
This is pretty minimal but covers the bare facts.
2011-03-25Remove alpha release notes.Robert Haas
Temporarily move some of the alpha release note disclaimers into the regular release notes, for the sake of alpha5.
2011-03-25Fix broken markup, and remove tabsAlvaro Herrera
2011-03-25Documented some ecpg command line options that were missing:Michael Meskes
-r no_indicator -r prepare -r questionsmarks
2011-03-24Edits to 9.1 release notes.Robert Haas
Add some new items and some additional details to existing items, mostly by cribbing from the 9.1alpha notes. Some additional clarifications and corrections elsewhere, and a few typo fixes.
2011-03-23Improve user-defined-aggregates documentation.Tom Lane
On closer inspection, that two-element initcond value seems to have been a little white lie to avoid explaining the full behavior of float8_accum. But if people are going to expect the examples to be exactly correct, I suppose we'd better explain. Per comment from Thom Brown.
2011-03-23Fix ancient typo in user-defined-aggregates documentation.Tom Lane
The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet.
2011-03-22Cosmetic capitalization fixPeter Eisentraut