PgSql

[BUGS] Invalid YAML output from EXPLAIN
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Dean Rasheed wrote: .... So the current code in escape_yaml() is inadequate for producing valid YAML. I think it would have to also consider at least the following characters as special "-" ":" "[" "]" "{" "}" "," "\"" "'" "|" "*" "&". Tech... 9 Jun 2010 14:12

psql: ON_ERROR_STOP command-line flag for scripts
* Mike Toews (mwtoews(a)gmail.com) wrote: I know I can either embed a non-SQL command in the SQL file or add --set ON_ERROR_STOP =1 to the command arguments, however I'd like a simpler command interface (just like there is -q / --quiet for QUIET). Could I suggest a new command-line option -r / --on-error-stop... 7 Jun 2010 13:00

[HACKERS] psql: ON_ERROR_STOP command-line flag for scripts
Hey hackers, I routinely run SQL scripts using pgsql -f myscript.sql. If there is an error mid-way in a large script file, due to the default ON_ERROR_STOP=0, I see repeated�"ERROR: �current transaction is aborted, commands ignored until end of�transaction block" until the end of the script. Often the error is b... 7 Jun 2010 13:00

[HACKERS] pgstatindex still throws ERROR: value "3220078592" is out of range for type integer
I noted on line 169 that max_avail is still an int ? Where else would it be having problems ? Dave -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 7 Jun 2010 11:53

pgsql: Add current WAL end (as seen by walsender, ie, GetWriteRecPtr()
On Fri, Jun 4, 2010 at 7:17 AM, Tom Lane <tgl(a)postgresql.org> wrote: Log Message: ----------- Add current WAL end (as seen by walsender, ie, GetWriteRecPtr() result) and current server clock time to SR data messages.  These are not currently used on the slave side but seem likely to be useful in future, ... 7 Jun 2010 11:53

[HACKERS] warning message in standby
Hi, When an error is found in the WAL streamed from the master, a warning message is repeated without interval forever in the standby. This consumes CPU load very much, and would interfere with read-only queries. To fix this problem, we should add a sleep into emode_for_corrupt_record() or somewhere? Or we shoul... 7 Jun 2010 09:39

: CRC32 is limiting at COPY/CTAS/INSERT... SELECT + speeding it up
> On Sunday 30 May 2010 18:29:31 Greg Stark wrote: On Sun, May 30, 2010 at 4:54 AM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: I read through that thread and couldn't find much discussion of alternative CRC implementations --- we spent all our time on arguing about whether we needed 64-bit CRC or not. ... 8 Jun 2010 09:10

SR slaves and .pgpass
On Mon, Jun 7, 2010 at 5:42 AM, Andrew Dunstan <andrew(a)dunslane.net> wrote: The docs state, w.r.t. $subject: � The password can be provided either in the primary_conninfo string � or in a separate ~/.pgpass file on the standby server. I tried this with a database name of "replication" in the .pgpas... 14 Jun 2010 07:20

[HACKERS] ps display "waiting for max_standby_delay"
Hi, We have codes to change ps display for recovery process during hot standby. The current code always shows max_standby_delay for the message, but how about showing actual waiting time instead? Since DBAs can always get the parameter from postgresql.conf they wrote, so the parameter value itself is not so usef... 7 Jun 2010 00:57

[HACKERS] SR slaves and .pgpass
The docs state, w.r.t. $subject: The password can be provided either in the primary_conninfo string or in a separate ~/.pgpass file on the standby server. I tried this with a database name of "replication" in the .pgpass file, which matches what we need to use in pg_hba.conf, but it failed miserabl... 6 Jun 2010 18:17