aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Remove partial and undocumented GRANT .. FOREIGN TABLE support.Robert Haas2011-04-25
| | | | | | | | | | | 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.
* Normalize whitespace in the arguments of <indexterm>Peter Eisentraut2011-04-25
| | | | | | | | | | | 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.
* Adjust comments about collate.linux.utf8 regression test.Tom Lane2011-04-23
| | | | | | | 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.
* Make a code-cleanup pass over the collations patch.Tom Lane2011-04-22
| | | | | | | 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().
* Improve doc wording for SQL syntax of LIMIT/OFFSET.Bruce Momjian2011-04-21
|
* Allow ALTER TYPE .. ADD ATTRIBUTE .. CASCADE to recurse to descendants.Robert Haas2011-04-20
| | | | | | | Without this, adding an attribute to a typed table with an inheritance child fails, which is surprising. Noah Misch, with minor changes by me.
* Allow ALTER TABLE name {OF type | NOT OF}.Robert Haas2011-04-20
| | | | | | | | | | | 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
* Document COLLATE option in CREATE TYPE reference page.Tom Lane2011-04-17
| | | | | Curiously, it was already documented in ALTER TYPE ADD ATTRIBUTE, but not here.
* Support a COLLATE clause in plpgsql variable declarations.Tom Lane2011-04-17
| | | | | | | 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.
* Note that Bison on GnuWin32 has trouble with paths with spacesMagnus Hagander2011-04-15
| | | | Peter Eisentraut
* Specify which versions of the Platform SDK are supportedMagnus Hagander2011-04-15
| | | | | Anything including Visual Studio 2010 compilers is not yet supported for building on Windows.
* Rename pg_regress option --multibyte to --encodingPeter Eisentraut2011-04-15
| | | | | Also refactor things a little bit so that the same methods for setting test locale and encoding can be used everywhere.
* Update release notes for releases 9.0.4, 8.4.8, 8.3.15, and 8.2.21.Tom Lane2011-04-14
|
* Advise Debian/Ubuntu users to use openjade1.3.Robert Haas2011-04-14
| | | | | | | The latest openjade packages for Ubuntu 10.10 seg fault when building our documentation. Josh Berkus
* Add some useful cross-references to the CREATE EXTENSION reference page.Tom Lane2011-04-13
| | | | | Per a suggestion from Josh Kupershmidt, though I modified his patch quite a lot.
* Teach regular expression operators to honor collations.Tom Lane2011-04-10
| | | | | | | | | | | | | | 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.
* Don't show unusable collations in psql's \dO command.Tom Lane2011-04-09
| | | | | | "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.
* Avoid extra whitespace in the arguments of <indexterm>.Tom Lane2011-04-08
| | | | | | | | | 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.
* Add an example of WITH (UPDATE RETURNING) INSERT to the INSERT ref page.Tom Lane2011-04-08
| | | | | | 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.
* Update key words table for 9.1Peter Eisentraut2011-04-06
|
* Change "Id" to "id" in some SGML tagsAlvaro Herrera2011-04-05
| | | | Gabriele Bartolini
* Typo fixes.Robert Haas2011-04-05
| | | | Erik Rijkers
* Add casts from int4 and int8 to numeric.Robert Haas2011-04-05
| | | | Joey Adams, per gripe from Ramanujam. Review by myself and Tom Lane.
* Centralise release note items related to recovery and replicationSimon Riggs2011-04-04
|
* Update comments and credit doc proofreadersSimon Riggs2011-04-04
|
* Merge synchronous_replication setting into synchronous_commit.Robert Haas2011-04-04
| | | | | | | | 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.
* Uppercase <!ENTITY> and <!DOCTYPE> tags in SGML sourceAlvaro Herrera2011-04-04
| | | | | | | This improves compatibility with external toolchains, such as those used by some documentation translation tools. Gabriele Bartolini
* Duplicate expansion of "direction" from FETCH's synopsis into MOVEAlvaro Herrera2011-04-04
|
* Improve documentation on the range of the numeric data type.Robert Haas2011-04-03
| | | | Gianni Ciolli, reviewed by Noah Misch
* Remove mention of using "man" from the tutorial.Robert Haas2011-04-03
| | | | | | | This isn't applicable on Windows, and the internal link to the psql documentation should be more than sufficient. Susanne Ebrecht
* Escape greater than and less than characters in docs.Heikki Linnakangas2011-04-02
| | | | Susanne Ebrecht and me
* Support comments on FOREIGN DATA WRAPPER and SERVER objects.Robert Haas2011-04-01
| | | | | | | | | | 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
* Reword the phrase on zero replication_timeout in the docs.Heikki Linnakangas2011-03-31
|
* Automatically terminate replication connections that are idle for moreHeikki Linnakangas2011-03-30
| | | | | | | | | 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
* Add maintainer-check targetPeter Eisentraut2011-03-28
| | | | | | 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.
* Add 9.1 release note link for synchronous replication.Bruce Momjian2011-03-28
| | | | We already had links to the GUC variables that control it.
* Mark up release notes using <link>.REL9_1_ALPHA5Robert Haas2011-03-28
| | | | Unlike <xref>, this actually works.
* Get rid of links that don't work when building HISTORY.Tom Lane2011-03-28
|
* Typo fix in SSI docs.Robert Haas2011-03-27
| | | | Kevin Grittner
* Correct "characters" to "bytes" in createdb docs.Robert Haas2011-03-27
| | | | Susanne Ebrecht
* Remove disclaimer stating that fsync=off slows down sync rep.Robert Haas2011-03-26
| | | | | The underlying problem that caused this phenomenon was fixed by commit 92f4786fa9b730fd12cbfe973eb96addc6e98924.
* Update release notes for latest commits.Robert Haas2011-03-26
| | | | | In addition, correct the entry for pg_object_description, and some other minor cleanup.
* Document collation handling in SQL and plpgsql functions.Tom Lane2011-03-25
| | | | This is pretty minimal but covers the bare facts.
* Remove alpha release notes.Robert Haas2011-03-25
| | | | | Temporarily move some of the alpha release note disclaimers into the regular release notes, for the sake of alpha5.
* Fix broken markup, and remove tabsAlvaro Herrera2011-03-25
|
* Documented some ecpg command line options that were missing:Michael Meskes2011-03-25
| | | | | | -r no_indicator -r prepare -r questionsmarks
* Edits to 9.1 release notes.Robert Haas2011-03-24
| | | | | | 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.
* Improve user-defined-aggregates documentation.Tom Lane2011-03-23
| | | | | | | 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.
* Fix ancient typo in user-defined-aggregates documentation.Tom Lane2011-03-23
| | | | | The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet.
* Cosmetic capitalization fixPeter Eisentraut2011-03-22
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-03 07:25:21 +0000