I spent the month of August going through 1.7k emails I had saved from
the previous year that required my attention. I want to thank everyone
for helping me close many open items, and for tolerating my questions.
Ideally I would have dealt with many of these emails earlier, but time
constraints caused the delay. On a bright note, August seems to be an
ideal time to catch up, and I plan on doing a similar cleaning next
August, hopefully with less backlog.
On a related note, I apologize that many of these items didn't make it
into 9.2, though they are committed for 9.3. The good news is that most
of my work was in documentation improvements and clarifications, that
could be backpatched to 9.2. I did not bring this up earlier because I
didn't want to distract the work of making the improvements.
If anyone wants to look at backpatching some of these doc changes into
9.2, I will not object. ;-) I am attaching a partial list of doc
changes that might be considered. (I need to improve my commit messages
that reference earlier commits by including the old commit tag; my
apologies.) No one has mentioned backpatching so perhaps these are all
too minor, which is fine.
Again, many thanks. I feel much better without the weight of
uncompleted items over my head.
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
commit 7682c5947dff4368753890935522dedfb93e1c78
Author: Bruce Momjian <br...@momjian.us>
Date: Sun Sep 2 09:16:26 2012 -0400
Update URLs that pointed to sun.com; either repoint them or remove
them.
commit 6c82a86c6f11815df371a310e3734030b1a635f4
Author: Bruce Momjian <br...@momjian.us>
Date: Sun Sep 2 08:41:51 2012 -0400
Add small doc mention that libpq is named after POSTQUEL.
commit f789909b59c59a33e34feac3bed2c86f18159122
Author: Bruce Momjian <br...@momjian.us>
Date: Fri Aug 31 16:55:49 2012 -0400
In pg_upgade, document that the port numbers must be different when
checking an old running server.
commit c36b06a70d303c738f092f264585f621b6b30b29
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 30 18:38:00 2012 -0400
Clarify FreeBSD instructions in pg_test_timing.
Josh Kupershmidt
commit b5dc7612a5f66a08c6d46656d359fc1c69670f36
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 30 17:58:36 2012 -0400
Properly document that SIGTERM is OK for users to use on a postgres
session, now that pg_terminate_backend() uses it.
Josh Kupershmidt
commit 39b42ecb059e24bb39a62d91fe57ab7b9ca5a2f5
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 30 16:56:12 2012 -0400
Document that max_locks_per_transaction might need to be increased for
queries on parent tables, per suggestion from Josh Berkus.
commit 83fbfec383d7f7ef1331ba02db3d0fdf50abf112
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 30 14:44:36 2012 -0400
Document that log_autovacuum_min_duration can be used to monitor
autovacuum activity.
Per report from Marc Mamin
commit 48a9c7823e032fde54cb0658fbd488809a3fdc69
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 30 13:13:35 2012 -0400
Remove old documentation warnings about the use of bigint.
commit 9fe6da5c0d8e70c9a541c3e1e0d637ab19c75ac1
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 29 21:45:31 2012 -0400
Document that NOTIFY events are visible to all users.
commit 5ea6c9d79882815d4cc1c3c302f415eb637466f2
Author: Bruce Momjian <br...@momjian.us>
Date: Tue Aug 28 12:17:11 2012 -0400
Update doc mention of how to compute bigint advisory lock value, per Tom
Lane's correction.
commit bf849af7f347ebcd394d6d789f557e75ead2f5ee
Author: Bruce Momjian <br...@momjian.us>
Date: Mon Aug 27 22:36:37 2012 -0400
Document how to create advisory lock "bigint" values in SQL.
David E. Wheeler
commit 483c2c1071c45e275782d33d646c3018f02f9f94
Author: Bruce Momjian <br...@momjian.us>
Date: Mon Aug 27 15:26:53 2012 -0400
Document the lack of reading the PGDATABASE environment variable in
pg_restore.
commit 7a42dff47e37e7cd7ba03a2ed6531f2d9a206e74
Author: Bruce Momjian <br...@momjian.us>
Date: Sun Aug 26 23:21:45 2012 -0400
Update FreeBSD kernel configuration documentation.
Brad Davis
commit de87d4704432e98a327dbf42dbc4711fa2628a9c
Author: Bruce Momjian <br...@momjian.us>
Date: Sun Aug 26 16:33:11 2012 -0400
Clarify documentation that primary key and unique constraints are copied
for CREATE TABLE LIKE ... INCLUDING INDEXES.
Per report from david.sahag...@emc.com
commit f6752ee59af4b95248c32b0ee6477a15b0e93c63
Author: Bruce Momjian <br...@momjian.us>
Date: Sat Aug 25 19:11:21 2012 -0400
Document clearly that psql \! parameter interpretation limitations are
the same as \copy.
commit 03af60c010aebc0a100416897ecb0948168c99c9
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 22 12:05:25 2012 -0400
Fix typo.
commit 7dff5b8edd898146ffa4afc2df3f9d5c67e43f0e
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 22 12:00:24 2012 -0400
Document that pg_reload_conf() is also an easy way to reload the
configuration file.
commit 1037f2f646d7c018c8968336afe3584a8c6e654d
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 16 18:41:38 2012 -0400
Document that tab completation can interfere with some SQL commands.
commit c99016f1d0ad122aaf9dca83b033277f97e55bd3
Author: Bruce Momjian <br...@momjian.us>
Date: Thu Aug 16 18:15:47 2012 -0400
Add warning about pg_ctl restart and the use of relative paths on the
command-line.
commit de3773d951bfc85d8860295248cf91db524a4ef8
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 23:57:19 2012 -0400
Fix SGML markup; missing tag.
commit 077908aed726b0e1605ed27156d7ebcf93a64d5d
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 22:59:37 2012 -0400
Document that PGDATA has to point to the configuration files, rather
than the actual data storage directory.
Per suggestion from Thom Brown
commit 6ff55ebe3dc790ebd80f9a26fa3d05867aee728e
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 20:52:12 2012 -0400
Document that pg_ctl -w allows for the entry of an SSL passphase on
startup.
Per report from Thom Brown
commit 16d508ccbc6f228c8c38dffbe9d295ac449c809b
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 20:38:01 2012 -0400
Add CREATE FOREIGN TABLE doc reference to CREATE SERVER.
Per suggestion from Ray Stell
commit 0729271adf9145900f59ec7a2053695bd551f4b1
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 20:29:58 2012 -0400
Properly document that NEW is unassigned in plpgsql for DELETE (not
NULL), and OLD is unassigned for INSERT, and NEW/OLD are unassigned (not
NULL) for statement-level triggers.
Per report from Pavel Stehule
commit fc5f20057f8666107f37d0c97fd6614054e72edc
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 11:47:02 2012 -0400
Document that foreign "version" and "type" values are only useful to
certain foreign data wrappers.
commit a973296598f2d1eec48138a2ce4f3e63410d9ed0
Author: Bruce Momjian <br...@momjian.us>
Date: Wed Aug 15 11:23:04 2012 -0400
Properly escape usernames in initdb, so names with single-quotes are
supported. Also add assert to catch future breakage.
Also, improve documentation that "double"-quotes must be used in
pg_hba.conf (not single quotes).
commit 864de654c8271ab7f9fb8397fcc665ffed93645c
Author: Bruce Momjian <br...@momjian.us>
Date: Tue Aug 14 23:25:20 2012 -0400
Add more limited large object trigger example.
commit 9e84cccff28e52ab76aa3d3e88bd815dc36d24d8
Author: Bruce Momjian <br...@momjian.us>
Date: Tue Aug 14 23:21:13 2012 -0400
Add doc example of restricting large object trigger firing to only
updates of the column of interest.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
