[COMMITTERS] pgsql: A toast relid field are no longer needed in pg_upgrade's rel arr

2011-01-10 Thread Bruce Momjian
A toast relid field are no longer needed in pg_upgrade's rel arrays, so remove them. Also other renaming. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0a5f11993195d74f23b63cc5c2d7024c6d27d7e2 Modified Files -- contrib/pg_upgra

[COMMITTERS] pgsql: Apply libpq documentation patches submitted by Leslie S Satenste

2011-01-12 Thread Bruce Momjian
Apply libpq documentation patches submitted by Leslie S Satenstein and reviewed by Robert Haas. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a0423ec02df3e311d6d5888170cb25a8c14bc6bf Modified Files -- doc/src/sgml/libpq.sgml |

[COMMITTERS] pgsql: More libpq documentation adjustments from Leslie S Satenstein, r

2011-01-13 Thread Bruce Momjian
More libpq documentation adjustments from Leslie S Satenstein, reviewed by Robert Haas. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=712dd95370fc6c3a8d20f71b8e195a7af3c50f42 Modified Files -- doc/src/sgml/libpq.sgml | 22

[COMMITTERS] pgsql: Apply patch for test_fsync to add tests for O_DIRECT.

2011-01-15 Thread Bruce Momjian
Apply patch for test_fsync to add tests for O_DIRECT. Adjusted patch by Josh Berkus Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=677b06ca462ec6fd98da9369a2eae6085c9d7fed Modified Files -- src/tools/fsync/Makefile |4 +-

[COMMITTERS] pgsql: Improve output display of test_fsync.

2011-01-15 Thread Bruce Momjian
Improve output display of test_fsync. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3ab80cfe031b616638eb6956010dcc9cb6426631 Modified Files -- src/tools/fsync/test_fsync.c | 35 ++- 1 files chang

[COMMITTERS] pgsql: Restructure test_fync to use modular C so there is less duplicat

2011-01-15 Thread Bruce Momjian
Restructure test_fync to use modular C so there is less duplicate code and it can be enhanced easier. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=169516ad9395e91d206cbf5bf32c5d2fa34d4111 Modified Files -- src/tools/fsync/READM

[COMMITTERS] pgsql: Have test_fsync output details that fdatasync is the default

2011-01-15 Thread Bruce Momjian
Have test_fsync output details that fdatasync is the default wal_sync_method on Linux. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=001d3664e32c0d156215bbfeccea3272aaf17722 Modified Files -- src/tools/fsync/test_fsync.c |3

[COMMITTERS] pgsql: In test_fsync, warn about options without o_direct that are not

2011-01-15 Thread Bruce Momjian
In test_fsync, warn about options without o_direct that are not used by Postgres, and cases where o_direct does not work with certain file systems. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=431605f666cfb223cd615ec8c63cbdea07295550 Modif

[COMMITTERS] pgsql: Reverse number of stars used for test_fsync details.

2011-01-15 Thread Bruce Momjian
Reverse number of stars used for test_fsync details. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3eebb33dddcfe4ac0719b697c1ebd3694038054e Modified Files -- src/tools/fsync/test_fsync.c | 24 1 files c

[COMMITTERS] pgsql: Use O_DIRECT in O_SYNC test of different size. Restructure O_DI

2011-01-15 Thread Bruce Momjian
Use O_DIRECT in O_SYNC test of different size. Restructure O_DIRECT error reporting to be more consistent. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6dc15e3befaa6a3ff72633a2084ad1e1466edcde Modified Files -- src/tools/fsync

[COMMITTERS] pgsql: In test_fsync, use #define for printf format of ops/sec.

2011-01-16 Thread Bruce Momjian
In test_fsync, use #define for printf format of ops/sec. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e0c274679cb50064a92472c94c7ef5849a156536 Modified Files -- src/tools/fsync/test_fsync.c |4 ++-- 1 files changed, 2 insert

[COMMITTERS] pgsql: Add getopt() support to test_fsync; also fix printf() format pr

2011-01-17 Thread Bruce Momjian
Add getopt() support to test_fsync; also fix printf() format problem. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=08af45f4ff89ff5bee25c7d5bf496e987eb90060 Modified Files -- src/tools/fsync/README |8 - src/tools/

[COMMITTERS] pgsql: In the docs, better distinguish server from client SSL settings

2011-01-17 Thread Bruce Momjian
In the docs, better distinguish server from client SSL settings in the documentation. Ray Stell Also fix some libpq title capitalization problems. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=74bcdfbe2dd656f04db4e883b5bdcdafddebff08 Mod

[COMMITTERS] pgsql: github test

2011-01-17 Thread Bruce Momjian
github test Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2c38cce1be4f57e353805e529e6d993c9c28535e Modified Files -- src/tools/fsync/README |3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) -- Sent via pgsql-committ

[COMMITTERS] pgsql: Remove "github test" that somehow got into my tree. Sorry.

2011-01-17 Thread Bruce Momjian
Remove "github test" that somehow got into my tree. Sorry. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4acfd43a7d6194fa735a6b7b06a1554909123d41 Modified Files -- src/tools/fsync/README |3 --- 1 files changed, 0 insertions

Re: [COMMITTERS] pgsql: github test

2011-01-17 Thread Bruce Momjian
Bruce Momjian wrote: > github test > > Branch > -- > master > > Details > --- > http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2c38cce1be4f57e353805e529e6d993c9c28535e > > Modified Files > -- > src/tools/fsync

[COMMITTERS] pgsql: In test_fsync, adjust test headings to match wal_sync_method val

2011-01-18 Thread Bruce Momjian
In test_fsync, adjust test headings to match wal_sync_method values; add more test cases for open_sync of different sizes. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8995440e387846261d18e728f11adc528ccc5c1b Modified Files --

[COMMITTERS] pgsql: Move test_fsync to /contrib.

2011-01-21 Thread Bruce Momjian
Move test_fsync to /contrib. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=606a3d54fcd053c31e52886f4c69848a68777480 Modified Files -- contrib/pg_test_fsync/Makefile | 23 ++ contrib/pg_test_fsync/test_fsync.c | 549 +++

[COMMITTERS] pgsql: Update C banner on new pg_test_fsync file.

2011-01-21 Thread Bruce Momjian
Update C banner on new pg_test_fsync file. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b35bfcae937810f43fdf2327bcea2e8a03ccbf68 Modified Files -- contrib/pg_test_fsync/test_fsync.c |3 --- 1 files changed, 0 insertions(+),

[COMMITTERS] pgsql: Update SGML docs to point to new /contrib/pg_test_fsync.

2011-01-21 Thread Bruce Momjian
Update SGML docs to point to new /contrib/pg_test_fsync. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5925aa09a9110fe0d12393c758812e7149546443 Modified Files -- doc/src/sgml/wal.sgml |4 ++-- 1 files changed, 2 insertions(+)

[COMMITTERS] pgsql: In test_open_sync(), writes kilobytes as intended, not by bytes.

2011-01-24 Thread Bruce Momjian
In test_open_sync(), writes kilobytes as intended, not by bytes. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9fc01922831aba350a61844882c229026ca8bf0b Modified Files -- contrib/pg_test_fsync/pg_test_fsync.c |3 ++- 1 files c

[COMMITTERS] pgsql: Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, bu

2011-01-24 Thread Bruce Momjian
Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, but verify it is 8k as expected. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9dd7933937a076ce7573944b8d1d42e618163440 Modified Files -- contrib/pg_test_fsync/pg_tes

[COMMITTERS] pgsql: Use consistent spacing for PGAPPICON Makefile option.

2011-01-24 Thread Bruce Momjian
Use consistent spacing for PGAPPICON Makefile option. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d7a714828f1a4d09adef68b58674a6266aa8fa03 Modified Files -- contrib/oid2name/Makefile |2 +- contrib/pg_archivecleanu

[COMMITTERS] pgsql: Update warning about synchronous-commit durability, per suggesti

2011-01-25 Thread Bruce Momjian
Update warning about synchronous-commit durability, per suggestion from Robvert Haas. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a91c950658016162020258574fb98aba182a5eac Modified Files -- doc/src/sgml/perform.sgml |2 +- 1

Re: [COMMITTERS] pgsql: Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, bu

2011-01-25 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, but verify > > it is 8k as expected. > > -#define WRITE_SIZE (8 * 1024) /* 8k */ > +#if XLOG_BLCKSZ != 8 * 1024 /* 8k */ > +#error Unknown block size for test.

Re: [COMMITTERS] pgsql: Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, bu

2011-01-25 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> If you aren't willing to deal with a variable value for the block size, > >> please revert this patch. > > > The problem is that I have hard-coded 8k into various text strings and I &g

Re: [COMMITTERS] pgsql: Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, bu

2011-01-25 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Sure I am willing to fix it. Should I have it always use the value of > > XLOG_BLCKSZ for its tests, and adjust the output text accordingly? > > Makes sense to me. OK, done with attached patch. I also cleaned up the open_sync s

[COMMITTERS] pgsql: Adjust pg_test_fsync to always do XLOG_BLCKSZ-sized writes, rath

2011-01-25 Thread Bruce Momjian
Adjust pg_test_fsync to always do XLOG_BLCKSZ-sized writes, rather than always 8k writes, per suggestion from Tom. Also adjust open_sync output layout. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=64bc872761bc9bf730307957f09f44a3eabbe3af

Re: [COMMITTERS] pgsql: Update warning about synchronous-commit durability, per suggesti

2011-01-26 Thread Bruce Momjian
Robert Haas wrote: > On Tue, Jan 25, 2011 at 8:32 PM, Bruce Momjian wrote: > > Update warning about synchronous-commit durability, per suggestion from > > Robvert Haas. > > The revised text is just as silly as the original text. The point is > that with fsync turned o

[COMMITTERS] pgsql: Update sync commit performance documentation to be consistent wi

2011-01-26 Thread Bruce Momjian
Update sync commit performance documentation to be consistent with other non-durable items, per Robert Haas. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e84730a916bce0635eb78205d2ea4746ee664d68 Modified Files -- doc/src/sgml/p

[COMMITTERS] pgsql: Update contrib documention mentions to point to actual documenta

2011-01-26 Thread Bruce Momjian
Update contrib documention mentions to point to actual documentation sections, rather than just calling it "/contrib/module_name". Also update pg_test_fsync build instructions now that it is in /contrib. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=com

[COMMITTERS] pgsql: In pg_test_fsync, use K(1024) rather than k(1000) for write size

2011-01-26 Thread Bruce Momjian
In pg_test_fsync, use K(1024) rather than k(1000) for write size units. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=00869024cb0164969957c1b3e8f6a11242a939e9 Modified Files -- contrib/pg_test_fsync/pg_test_fsync.c | 18 ++

[COMMITTERS] pgsql: Per Peter E, use 'kB' for kilobyte, not 'K'.

2011-01-26 Thread Bruce Momjian
Per Peter E, use 'kB' for kilobyte, not 'K'. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4fec63f94e8edb6181eb3e1e25e979062ab17450 Modified Files -- contrib/pg_test_fsync/pg_test_fsync.c | 18 +- 1 files change

[COMMITTERS] pgsql: Restructure streaming docs so streaming seems more integrated in

2011-01-26 Thread Bruce Momjian
Restructure streaming docs so streaming seems more integrated in the paragraphs, per suggestion from Dan Birken. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=81c48aeaa8fd34f90ab6d6f1d56564d34ac4aa59 Modified Files -- doc/src/sg

[COMMITTERS] pgsql: Update non-durable docs about non-synchronous-commit allowing

2011-01-27 Thread Bruce Momjian
Update non-durable docs about non-synchronous-commit allowing transaction loss for a _database_ crash. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b34ee30115fb6b8da8c3024705bd4ba0339212c1 Modified Files -- doc/src/sgml/perform

[COMMITTERS] pgsql: Properly capitalize documentation headings; some only had initi

2011-01-29 Thread Bruce Momjian
Properly capitalize documentation headings; some only had initial-word capitalization. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5d5678d7c3b336a5aacf15d66ac3ebccaab929f2 Modified Files -- doc/src/sgml/adminpack.sgml

[COMMITTERS] pgsql: Move upgrade instructions into its own section under "Server Set

2011-01-31 Thread Bruce Momjian
Move upgrade instructions into its own section under "Server Setup and Operation", merged from upgrade sections in "Installation from Source Code" and "Backup and Restore". This now gives a single place for all upgrade information. Branch -- master Details --- http://git.postgresql.org/g

[COMMITTERS] pgsql: Fix SGML markup for upgrade doc addition.

2011-01-31 Thread Bruce Momjian
Fix SGML markup for upgrade doc addition. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ff20fbd6c21929cd5c78f154c8364ce746de9c03 Modified Files -- doc/src/sgml/runtime.sgml |4 ++-- 1 files changed, 2 insertions(+), 2 deletio

[COMMITTERS] pgsql: Update pg_upgrade docs to mention its use in a less risk-warning

2011-01-31 Thread Bruce Momjian
Update pg_upgrade docs to mention its use in a less risk-warning way, and update the pg_upgrade docs to mention its reliance on no changes to the storage format (the later based on Robert Haas's patch). Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commi

[COMMITTERS] pgsql: Fix pg_upgrade to create pg_authid restore functions in the 'pos

2011-01-31 Thread Bruce Momjian
Fix pg_upgrade to create pg_authid restore functions in the 'postgres' database, not in the os-user database, per report from Magnus. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6238473adb119a5a11061e40e159e8c5187fe492 Modified Files

[COMMITTERS] pgsql: In pg_authid.rolpassword docs, make "md5" appear as a literal.

2011-01-31 Thread Bruce Momjian
In pg_authid.rolpassword docs, make "md5" appear as a literal. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2dbed56c5a86d45a66f41e6a8a16295bbfe46646 Modified Files -- doc/src/sgml/catalogs.sgml |2 +- 1 files changed, 1 inse

[COMMITTERS] pgsql: Improve docs for pg_authid encryption description with better ma

2011-01-31 Thread Bruce Momjian
Improve docs for pg_authid encryption description with better markup and a mention of unencrypted passwords. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=00dd340210ed67900e03703eb088fdd5ab12c099 Modified Files -- doc/src/sgml/c

[COMMITTERS] pgsql: Add pg_upgrade comment for why we can't use template1 inheritanc

2011-02-01 Thread Bruce Momjian
Add pg_upgrade comment for why we can't use template1 inheritance for the support functions. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2bb87a61a84ab74b7ba820aac787443a78897bf4 Modified Files -- contrib/pg_upgrade/pg_upgrade.

[COMMITTERS] pgsql: Add missing period "." in pg_upgrade documentation.

2011-02-01 Thread Bruce Momjian
Add missing period "." in pg_upgrade documentation. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d2888d1ca36c266900eeea95401269c782074251 Modified Files -- doc/src/sgml/pgupgrade.sgml |2 +- 1 files changed, 1 insertions(+),

[COMMITTERS] pgsql: Clarify pg_upgrade install instructions, per suggestion from Rob

2011-02-01 Thread Bruce Momjian
Clarify pg_upgrade install instructions, per suggestion from Robert Haas. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=902aae5ec58f71b8d9f7efb5ed474d0f5439439d Modified Files -- doc/src/sgml/pgupgrade.sgml |4 ++-- 1 files c

[COMMITTERS] pgsql: Document that Slony can do upgrades easier _because_ it supports

2011-02-01 Thread Bruce Momjian
Document that Slony can do upgrades easier _because_ it supports replication between different Postgres major versions. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e8cdc238cfa3fda4185fe6a9826dbdf0a107f789 Modified Files -- doc

[COMMITTERS] pgsql: Document that effective cache size does not assume data remains

2011-02-01 Thread Bruce Momjian
Document that effective cache size does not assume data remains in the cache between queries. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6c6e6f7fd3ffa984a202b910ef3237e26f9d3c2e Modified Files -- doc/src/sgml/config.sgml |

[COMMITTERS] pgsql: Clarify documentation to state that "zero_damaged_pages" does no

2011-02-01 Thread Bruce Momjian
Clarify documentation to state that "zero_damaged_pages" does not force data to disk, so the table or index should be recreated before the parameter is turned off again. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7106f74e2a6feb31c022dd98e

[COMMITTERS] pgsql: Properly capitalize hyphenated words in documentation titles.

2011-02-01 Thread Bruce Momjian
Properly capitalize hyphenated words in documentation titles. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d56d246e70184692408cd6a444e6824ae8491587 Modified Files -- doc/src/sgml/backup.sgml |2 +- doc/src/sgml/bib

[COMMITTERS] pgsql: Document that CREATE VIEW that uses "*" for the column list will

2011-02-01 Thread Bruce Momjian
Document that CREATE VIEW that uses "*" for the column list will not auto-add columns later added to the base table. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5a6ba62be5364dbf973fd9b8631fd60acda03440 Modified Files -- doc/sr

[COMMITTERS] pgsql: Simplify pg_upgrade checking of executable permissions.

2011-02-02 Thread Bruce Momjian
Simplify pg_upgrade checking of executable permissions. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9d220fc17eafcbc99fcea7bdbbb246fee473eac7 Modified Files -- contrib/pg_upgrade/exec.c | 73 +++---

[COMMITTERS] pgsql: Fix wrong verb in pg_upgrade text message, per Haas.

2011-02-02 Thread Bruce Momjian
Fix wrong verb in pg_upgrade text message, per Haas. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2b6e2dee7805ec5b477af00c01c54c208bf106eb Modified Files -- contrib/pg_upgrade/check.c |2 +- 1 files changed, 1 insertions(+),

[COMMITTERS] pgsql: Mark all GUC variables with markup, rather than

2011-02-02 Thread Bruce Momjian
Mark all GUC variables with markup, rather than . Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=03c25dd900d97c0868ad20b925a78d41ec603578 Modified Files -- doc/src/sgml/datetime.sgml |6 ++-- doc/src/sgml/libpq.sgml

[COMMITTERS] pgsql: Clearify macro IS_PATH_VAR_SEP in path.c so it is clear this is

2011-02-02 Thread Bruce Momjian
Clearify macro IS_PATH_VAR_SEP in path.c so it is clear this is a path variable, not a directory path. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=bffb638d16999ee7d3c8796e77dd87ac82719c7d Modified Files -- src/port/path.c |

[COMMITTERS] pgsql: Rename function to first_path_var_separator() to clarify it work

2011-02-02 Thread Bruce Momjian
Rename function to first_path_var_separator() to clarify it works with path variables, not directory paths. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=426227850be145b52cb610455000fc005df5ce4e Modified Files -- src/backend/uti

[COMMITTERS] pgsql: Simplify code used in is_absolute_path() macro; also add commen

2011-02-03 Thread Bruce Momjian
Simplify code used in is_absolute_path() macro; also add comment about 'E:abc' Win32 path handling. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=35b0a6b205c25d592b966aa17d3c6f9e5a88eb62 Modified Files -- src/include/port.h |

[COMMITTERS] pgsql: In docs, PL is Procedural Language, not Programming Language.

2011-02-03 Thread Bruce Momjian
In docs, PL is Procedural Language, not Programming Language. Satoshi Nagayasu Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=df63aac678343cec522bc58588b70ab1374a6c93 Modified Files -- doc/src/sgml/acronyms.sgml |2 +- 1 file

[COMMITTERS] pgsql: In docs, move PQrequestCancel() deprecation mention up to match

2011-02-04 Thread Bruce Momjian
In docs, move PQrequestCancel() deprecation mention up to match other libpq doc mentions. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b157a1d5554d6dfbd13fb605f08d51ce17532375 Modified Files -- doc/src/sgml/libpq.sgml |8 ++

[COMMITTERS] pgsql: Add doc comment that installation.sgml can't use xrefs.

2011-02-04 Thread Bruce Momjian
Add doc comment that installation.sgml can't use xrefs. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8e6ae3d79c16ad8876c34f2cff8d667ca1cffb09 Modified Files -- doc/src/sgml/installation.sgml |6 ++ 1 files changed, 6 ins

[COMMITTERS] pgsql: Add C comment about why older compilers complain about basebacku

2011-02-04 Thread Bruce Momjian
Add C comment about why older compilers complain about basebackup.c's longjump. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=51dbc87dff5c32bfe627ec7b22c575c263de8251 Modified Files -- src/backend/replication/basebackup.c |6

Re: [COMMITTERS] pgsql: Mention why one C file fails pgindent.

2011-02-06 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Bruce Momjian wrote: > > Log Message: > > --- > > Mention why one C file fails pgindent. > > > > Modified Files: > > -- > > pgsql/src/tools/pgindent: > > README (r1.41 -> r1.42

[COMMITTERS] pgsql: Rename macro DECIMAL to DECIMAL_T to help pgindent; this is alr

2011-02-06 Thread Bruce Momjian
Rename macro DECIMAL to DECIMAL_T to help pgindent; this is already done for a few other macros in that file, for other reasons. I also remove pgindent/README mention of the file. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=97116ca4170b9

[COMMITTERS] pgsql: Adjust libpq docs to be clearer about 'hostaddr' usage by reword

2011-02-06 Thread Bruce Momjian
Adjust libpq docs to be clearer about 'hostaddr' usage by rewording and using an itemized list. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5ed45ac09c604555740e7365a722b641f3bce498 Modified Files -- doc/src/sgml/libpq.sgml |

[COMMITTERS] pgsql: remove tags.

2011-02-06 Thread Bruce Momjian
remove tags. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ad762426333aac5bd8e1ceac753bebe4a6411c28 Modified Files -- doc/src/sgml/advanced.sgml |2 +- doc/src/sgml/array.sgml |2 +- doc/src/sgml/backu

Re: [COMMITTERS] pgsql: remove tags.

2011-02-06 Thread Bruce Momjian
Bruce Momjian wrote: > remove tags. Sorry, vague commit message (I forgot squash). Can I will use git ammend to improve this message? --- > > Branch > -- > master > > Details > --- >

[COMMITTERS] pgsql: Remove tabs in SGML file.

2011-02-09 Thread Bruce Momjian
Remove tabs in SGML file. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ee4b67fcff9cce85812639b3a0ef14f5bcf85f99 Modified Files -- doc/src/sgml/recovery-config.sgml | 12 ++-- 1 files changed, 6 insertions(+), 6 deletions(-) -- Sent via pgsq

[COMMITTERS] pgsql: Remove more SGML tabs.

2011-02-09 Thread Bruce Momjian
Remove more SGML tabs. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/70802e0dbef0af4bf73ce25489b8be6e40eca2be Modified Files -- doc/src/sgml/recovery-config.sgml |4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) -- Sent via pgsql-committer

[COMMITTERS] pgsql: Fix pg_get_encoding_from_locale() function call parameters to ma

2011-02-10 Thread Bruce Momjian
Fix pg_get_encoding_from_locale() function call parameters to match prototype for cases where there is no multi-language support. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2432d10bf243ad0ca9b5ccc2816e4e38e1d80b5e Modified Files -- src/port/chklocale

[COMMITTERS] pgsql: Fix "variable not used" warnings when USE_WIDE_UPPER_LOWER is no

2011-02-10 Thread Bruce Momjian
Fix "variable not used" warnings when USE_WIDE_UPPER_LOWER is not defined. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/135724ec357f9b9c8800567444724c72da2cc6be Modified Files -- src/backend/tsearch/ts_locale.c |2 ++ src/backend/tsearch/wparser_d

[COMMITTERS] pgsql: Properly handle Win32 paths of 'E:abc', which can be either abso

2011-02-12 Thread Bruce Momjian
Properly handle Win32 paths of 'E:abc', which can be either absolute or relative, by creating a function path_is_relative_and_below_cwd() to check for specific requirements. It is unclear if this fixes a security problem or not but the new code is more robust. Branch -- master Details --

[COMMITTERS] pgsql: Fix reverse 'if' test in path_is_relative_and_below_cwd(), per T

2011-02-12 Thread Bruce Momjian
Fix reverse 'if' test in path_is_relative_and_below_cwd(), per Tom. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8e7af608722a25376d31c40e4bd9916e932bc3ca Modified Files -- doc/src/sgml/libpq.sgml | 46 - d

Re: [COMMITTERS] pgsql: Fix reverse 'if' test in path_is_relative_and_below_cwd(), per T

2011-02-12 Thread Bruce Momjian
Bruce Momjian wrote: > Fix reverse 'if' test in path_is_relative_and_below_cwd(), per Tom. > > Branch > -- > master > > Details > --- > http://git.postgresql.org/pg/commitdiff/8e7af608722a25376d31c40e4bd9916e932bc3ca > > Modified Files

Re: [COMMITTERS] pgsql: Properly handle Win32 paths of 'E:abc', which can be either abso

2011-02-12 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Properly handle Win32 paths of 'E:abc', which can be either absolute or > > relative, by creating a function path_is_relative_and_below_cwd() to > > check for specific requirements. It is unclear if this fixes a security

[COMMITTERS] pgsql: Back out libpq doc change; not ready yet.

2011-02-12 Thread Bruce Momjian
Back out libpq doc change; not ready yet. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cebbaa1d5d2729c1b9dde0b472b4b034ef2f44b0 Modified Files -- doc/src/sgml/libpq.sgml | 46 + doc/src/sgml/release-9.0.s

[COMMITTERS] pgsql: Clarify documentation for libpq's PQescapeBytea to mention the n

2011-02-13 Thread Bruce Momjian
Clarify documentation for libpq's PQescapeBytea to mention the new hex format. Modify PQescapeStringConn() docs to be consisent with other escaping functions. Add mention problems with pre-9.0 versions of libpq using not understanding bytea hex format to the 9.0 release notes. Backpatch to 9.0 d

[COMMITTERS] pgsql: Clarify documentation for libpq's PQescapeBytea to mention the n

2011-02-13 Thread Bruce Momjian
Clarify documentation for libpq's PQescapeBytea to mention the new hex format. Modify PQescapeStringConn() docs to be consisent with other escaping functions. Add mention problems with pre-9.0 versions of libpq using not understanding bytea hex format to the 9.0 release notes. Backpatch to 9.0 d

[COMMITTERS] pgsql: Adjust pg_upgrade error message, array freeing, and add error ch

2011-02-15 Thread Bruce Momjian
Adjust pg_upgrade error message, array freeing, and add error check. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/fe8f15d5d2f42ad1ce6a0114c12fd3da0f14dd4a Modified Files -- contrib/pg_upgrade/check.c |2 -- contrib/pg_upgrade/info.c|

[COMMITTERS] pgsql: Fix bug in 9.1 pg_upgrade processing of old/new relations; adju

2011-02-15 Thread Bruce Momjian
Fix bug in 9.1 pg_upgrade processing of old/new relations; adjust debug output. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1cc19cc358c23e3c4e04f9f38776b625d5e13965 Modified Files -- contrib/pg_upgrade/info.c |8 +--- 1 files changed, 5 insert

Re: [COMMITTERS] pgsql: Adjust pg_upgrade error message, array freeing, and add error ch

2011-02-15 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Adjust pg_upgrade error message, array freeing, and add error check. > > The buildfarm says this patch is broken. Thanks, fixed a few hours ago. -- Bruce Momjian http://momjian.us EnterpriseDB

[COMMITTERS] pgsql: In pg_upgrade, no need to initialize global struct values; they

2011-02-16 Thread Bruce Momjian
In pg_upgrade, no need to initialize global struct values; they are always zeros. Also no need to free memory before we exit. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/497e65f822ff33ed964d1c891ee6de0d97d0b2a6 Modified Files -- contrib/pg_upgrade/i

[COMMITTERS] pgsql: In documentation example, use concat_values() instead of concat(

2011-02-17 Thread Bruce Momjian
In documentation example, use concat_values() instead of concat() because concat() is a built-in function. Erik Rijkers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/732808c087a84feed4749ab1e8a63ceeefcf449f Modified Files -- doc/src/sgml/xfunc.sgml |

[COMMITTERS] pgsql: Document that plpgsql upsert example can fail if insert triggers

2011-02-17 Thread Bruce Momjian
Document that plpgsql upsert example can fail if insert triggers return unique exception, or if not used in read committed transaction mode. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f87712d208f7dbe447cd27e92a99f49fd19afe94 Modified Files -- doc/src

[COMMITTERS] pgsql: Remove doc mention about read committed in upsert example.

2011-02-17 Thread Bruce Momjian
Remove doc mention about read committed in upsert example. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3472a2b0565ad0302e5ea47e49a95305c2b07f64 Modified Files -- doc/src/sgml/plpgsql.sgml |3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) -

[COMMITTERS] pgsql: Typo fix

2011-02-17 Thread Bruce Momjian
Typo fix Erik Rijkers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4f2cfc5bb4c404c24d589339d29c210321f4b4d7 Modified Files -- doc/src/sgml/ecpg.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing lis

Re: [COMMITTERS] pgsql: Use $INDENT rather than indent throughout the pgindent code

2011-02-17 Thread Bruce Momjian
Andrew Dunstan wrote: > > > On 02/17/2011 08:23 PM, Alvaro Herrera wrote: > > Use $INDENT rather than indent throughout the pgindent code > > > +INDENT=`which indent` > > How universally available is "which"? I have 'which'. I am unclear ho

Re: [COMMITTERS] pgsql: Use $INDENT rather than indent throughout the pgindent code

2011-02-18 Thread Bruce Momjian
Alvaro Herrera wrote: > Excerpts from Tom Lane's message of vie feb 18 00:34:33 -0300 2011: > > Bruce Momjian writes: > > > Andrew Dunstan wrote: > > >> On 02/17/2011 08:23 PM, Alvaro Herrera wrote: > > >>> Use $INDENT rather than indent througho

[COMMITTERS] pgsql: Document that text search comparisons happen after text search

2011-02-18 Thread Bruce Momjian
Document that text search comparisons happen after text search configuration rules. Erik Rijkers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5bba4948eb835413cc4a5ca1e2f7255ce4c78e69 Modified Files -- doc/src/sgml/datatype.sgml | 23

[COMMITTERS] pgsql: Improve text search prefix doc addition.

2011-02-18 Thread Bruce Momjian
Improve text search prefix doc addition. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4077980d67a2f27b88a6bc7531da31cae0ed0fb1 Modified Files -- doc/src/sgml/datatype.sgml |9 +++-- 1 files changed, 3 insertions(+), 6 deletions(-) -- Sent via

[COMMITTERS] pgsql: Initialize variable to quiet compiler.

2011-02-19 Thread Bruce Momjian
Initialize variable to quiet compiler. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/964b46d00ecc1273bec3ead369f3e167d482 Modified Files -- src/pl/plperl/plperl.c |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-commit

[COMMITTERS] pgsql: Document that an SQL-standard-compliant query that expects a uni

2011-02-19 Thread Bruce Momjian
Document that an SQL-standard-compliant query that expects a unique row from information_schema.referential_constraints might return several in Postgres because we allow duplicate-named constraints in the same schema. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e0

[COMMITTERS] pgsql: Documentation update for UTF16 surrogate pairs in UTF8 encoding.

2011-02-19 Thread Bruce Momjian
Documentation update for UTF16 surrogate pairs in UTF8 encoding. Marko Kreen Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8c0f1e2762a896e3af890b14babd3409fa49e641 Modified Files -- doc/src/sgml/syntax.sgml |7 +++ 1 files changed, 3 insertions(

[COMMITTERS] pgsql: Adjust documentation wording of window function ORDER BY to not

2011-02-19 Thread Bruce Momjian
Adjust documentation wording of window function ORDER BY to not mention avg() because it was inaccurate. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d5813488a4ccc78ec3a4ad0d5da4e6e844af75e8 Modified Files -- doc/src/sgml/advanced.sgml |8

[COMMITTERS] pgsql: Merge two documentation permission chapters into a single chapte

2011-02-20 Thread Bruce Momjian
Merge two documentation permission chapters into a single chapter. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/48d25bac9f024f36b43cbba58778adf9ad0207c6 Modified Files -- doc/src/sgml/ddl.sgml| 48 +--- doc/src/sgml/user-ma

[COMMITTERS] pgsql: Update docs about new role privileges reference, per Alvaro.

2011-02-21 Thread Bruce Momjian
Update docs about new role privileges reference, per Alvaro. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ede45e90dd1992bfd3e1e61ce87bad494b81f54d Modified Files -- doc/src/sgml/user-manag.sgml |4 ++-- 1 files changed, 2 insertions(+), 2 deletions(

[COMMITTERS] pgsql: Move information_schema duplicate constraint note to the top of

2011-02-21 Thread Bruce Momjian
Move information_schema duplicate constraint note to the top of the information schema documentation because it affects several tables. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/fee7802770669398359c369aee83277dcc58edd1 Modified Files -- doc/src/sgml

[COMMITTERS] pgsql: Reword information_schema duplicate constraint warning text.

2011-02-22 Thread Bruce Momjian
Reword information_schema duplicate constraint warning text. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/edb382179d49105a236b54678a5a4020276df071 Modified Files -- doc/src/sgml/information_schema.sgml | 15 --- 1 files changed, 8 insertio

[COMMITTERS] pgsql: Update wording about information schema and name which views pot

2011-02-22 Thread Bruce Momjian
Update wording about information schema and name which views potentially can have duplicates, per request from Tom. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2c72d7042bc09bd8a1f2dc8ab288fec449760ba8 Modified Files -- doc/src/sgml/information_schema.

[COMMITTERS] pgsql: Document pg_options_to_table() (not previously documented)

2011-02-25 Thread Bruce Momjian
Document pg_options_to_table() (not previously documented) Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/772dcfe7c0b3c678c8aef11de2bf8a52150a56f1 Modified Files -- doc/src/sgml/func.sgml | 15 +++ 1 files changed, 15 insertions(+), 0 deleti

[COMMITTERS] pgsql: Fix doc patch --- pg_options_to_table() returns "setof record".

2011-02-26 Thread Bruce Momjian
Fix doc patch --- pg_options_to_table() returns "setof record". Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/86434afb11093ba4e2893b717858d8ce790f3e2e Modified Files -- doc/src/sgml/func.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-)

[COMMITTERS] pgsql: Document that pg_options_to_table() also works for

2011-02-26 Thread Bruce Momjian
Document that pg_options_to_table() also works for pg_attribute.attoptions. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/58838a7a52a913c66084158f98f1f62349ee6335 Modified Files -- doc/src/sgml/func.sgml |7 --- 1 files changed, 4 insertions(+),

  1   2   3   4   5   6   7   8   9   10   >