PgSql

Stefan's bug (was: max_standby_delay consideredharmful)
On Wed, 2010-05-19 at 08:21 -0400, Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: On Wed, May 19, 2010 at 1:47 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: Yes, but I prefer XLogCtl->SharedRecoveryInProgress, which is the almost same indicator as the boolean you suggested. Thought? ... 19 May 2010 09:20

ecmascript 5 DATESTYLE
On Tue, May 18, 2010 at 6:26 PM, Ben Hockey <neonstalwart(a)gmail.com> wrote: hi, i mistakenly had posted this to pgsql-bugs already and got a response (see below - edited).  i'm posting here since afaik it is the way i should be requesting new features.  my suggestion is to add a DATESTYLE format to match... 20 May 2010 23:46

Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle
On May 17, 2010, at 3:30 , Robert Haas wrote: On Sun, May 16, 2010 at 9:07 PM, Florian Pflug <fgp(a)phlo.org> wrote: On May 14, 2010, at 22:54 , Robert Haas wrote: On Thu, May 13, 2010 at 5:39 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Florian Pflug <fgp(a)phlo.org> writes: All in all, I believe that ... 21 May 2010 08:24

[HACKERS] ecmascript 5 DATESTYLE
hi, i mistakenly had posted this to pgsql-bugs already and got a response (see below - edited). i'm posting here since afaik it is the way i should be requesting new features. my suggestion is to add a DATESTYLE format to match the format specified for date time strings in ecmascript 5. the followin... 18 May 2010 19:15

[HACKERS] BYTEA / DBD::Pg change in 9.0 beta
Hi. I'm trying to do a test move of one of our applications onto 9.0beta1. We use storable and serializes data into a bytea column in the database. This script uses that: #!/usr/bin/perl use strict; use warnings; use Storable; use DBI; use DBD::Pg; use Data::Dumper; my $dbh = DBI->connect("dbi:Pg:dbnam... 18 May 2010 17:01

Unexpected data beyond EOF during heavy writes
Excerpts from Tony Sullivan's message of mar may 18 13:19:13 -0400 2010: Hello everyone, We are seeing the following error message occasionally in the postgres logs: 2010-05-13 23:49:03 PDT ERROR: unexpected data beyond EOF in block 4106698 of relation "custom_discoveryprofile" 2010-05-13 23:49:03 P... 20 May 2010 19:25

pg_upgrade - link mode and transaction-wraparound data loss
Excerpts from jesper's message of mar may 18 13:22:12 -0400 2010: jk(a)pal:~$ psql data psql (9.0beta1, server 8.4.1) WARNING: psql version 9.0, server version 8.4. Some psql features might not work. Type "help" for help. data# SELECT datname, datfrozenxid FROM pg_database; datname ... 18 May 2010 17:01

Documentation Bug/Misnomer?
On Tue, May 18, 2010 at 12:49 PM, Stephen Frost <sfrost(a)snowman.net> wrote: Greetings, Under: http://developer.postgresql.org/pgdocs/postgres/runtime-config-file-locations.html We have: ident_file (string)    Specifies the configuration file for ident authentication        (customari... 18 May 2010 15:54

pg_upgrade - link mode and transaction-wraparound data loss
> jesper(a)krogh.cc wrote: Hi I tried running pg_upgrade from the current snapshot of postgresql and upgrading from 8.4.4 to the snapshot version. Everything seem to look fine in the process and all that came out was only "ok's" but when I tried a simple query on the databse it keeps throwing ... 18 May 2010 13:40

pg_upgrade - link mode andtransaction-wraparound data loss
jesper(a)krogh.cc wrote: Hi I tried running pg_upgrade from the current snapshot of postgresql and upgrading from 8.4.4 to the snapshot version. Everything seem to look fine in the process and all that came out was only "ok's" but when I tried a simple query on the databse it keeps throwing these messa... 19 May 2010 16:02