PgSql

master in standby mode croaks
On Tue, 2010-03-30 at 22:40 -0400, Robert Haas wrote: I discovered tonight that if you shut down a server, create recovery.conf with standby_mode = 'on', and start it back up again, you get this: LOG: database system was shut down at 2010-03-30 22:34:09 EDT LOG: entering standby mode FATAL: rec... 20 Apr 2010 18:31

mremap and bus error
On Wed, Mar 31, 2010 at 11:05 AM, Pavel Stehule <pavel.stehule(a)gmail.com> wrote: Can somebody help me? I think it's pretty hopeless to try to debug this without the complete source code... ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscripti... 1 Apr 2010 13:31

missing schema qualifications in psql
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 While psql is careful to schema-qualify all references to built-in objects (pg_catalog.*), it completely neglects to do this for built-in operators, which can lead to surprising misbehaviors when users have created custom operators. Here is a patch ... 1 Apr 2010 12:23

[HACKERS] ECPG check variables hidden by locals v2
Hi, here's a little beautified patch: - more logical parameter order in ECPGdump_a_type() - use mm_strdup() instead of strdup() (I notoriously forget this) - actually bail out with ET_FATAL if the local variable is of a different type than the global variable that was used in the DECLARE in the global scope... 1 Apr 2010 04:40

psql: edit function, show function commands patch
2010/4/1 Bruce Momjian <bruce(a)momjian.us>: I have added this to the next commit-fest. thank you Pavel --------------------------------------------------------------------------- Pavel Stehule wrote: Hello this simple patch allow to specify cursor row when some function is opened in... 1 Apr 2010 02:31

[HACKERS] Alias to rollback keyword
Hey, After dealing with a production fault and having to rollback all the time, I kept typing a different word instead of rollback. So I created a patch to accept this word as an alias for rollback. Obviously it's not part of the sql standard, but could be a nice extension for postgresql. See the patch for ... 31 Mar 2010 23:15

[DOCS] Streaming replication document improvements
On Wed, Mar 31, 2010 at 9:50 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: That's an interesting point, do streaming replication connections consume superuser_reserved_connections slots? Yes. Since SR connection is superuser connection, setting superuser_reserved_connections appropriately would be use... 23 Apr 2010 21:20

psql: edit function, show function commandspatch
I have added this to the next commit-fest. --------------------------------------------------------------------------- Pavel Stehule wrote: Hello this simple patch allow to specify cursor row when some function is opened in editor. \e aaa.txt \a aaa.txt 3 ... move cursor on 3nd line of te... 31 Mar 2010 18:50

[HACKERS] CHAR(10) - Clustering, High Availability and Replication conference
http://www.char10.org/ announced today... PostgreSQL CHAR(10) Conference is in Oxford, UK on 1-3 July 2010, at Oriel College, Oxford University. CHAR(10) stands for Clustering, High Availability, Replication, though includes all forms of Parallel, Distributed and Grid architectures. The Call for Papers is... 31 Mar 2010 15:28

pgindent excluded files list
On Wed, Mar 31, 2010 at 10:27:03AM -0400, Andrew Dunstan wrote: I propose that we create a file containing the list of patterns to exclude from pgindent runs. It would look like this: #list of file patterns to exclude from pg_indent runs /s_lock\.h$ /ecpg/test/expected/ /snowball/l... 31 Mar 2010 22:10