PgSql

[HACKERS] what is good solution for support NULL inside string_to_array function?
Hello I understand why we don't support expression 'null'::sometype. But it does problems with array deserialisation. postgres=# select array_to_string(ARRAY[10,20,30,NULL,30], '|'); array_to_string ----------------- 10|20|30|30 (1 row) quietly removing NULL is maybe good for compatibility but is wrong ... 3 May 2010 18:44

[HACKERS] buildfarm building all live branches from git
For those who have been following along, today I reached a bit of a milestone. The buildfarm member quoll, which is running a git-ized buildfarm client due to be released in a week or so, today successfully built all the live branches, all the way back to 7.4, from git. Note, this is running from my test git ... 3 May 2010 16:28

[HACKERS] Streaming replication - unable to stop the standby
I'm currently testing SR/HS in 9.0beta1 and I noticed that it seems quite easy to end up in a situation where you have a standby that seems to be stuck in: $ psql -p 5433 psql: FATAL: the database system is shutting down but not not actually shuting down ever. I ran into that a few times now (mostly becau... 3 May 2010 14:15

max_standby_delay considered harmful
On Mon, 2010-05-03 at 11:37 -0400, Tom Lane wrote: I've finally wrapped my head around exactly what the max_standby_delay code is doing, and I'm not happy with it. Yes, I don't think I'd call it perfect yet. have the slave cancel competing queries if the replay process waits more than max_standby_del... 14 May 2010 19:25

Further Hot Standby documentation required
Simon Riggs wrote: Recent changes to parameters aren't yet sufficiently well documented and I'd like to see this improved by the authors of those patches. I accept the behaviour changes, but we need full docs to explain them. * hot_standby doesn't mention that wal_level = hot_standby is also requ... 3 May 2010 17:37

[HACKERS] Show schema in COPY error CONTEXT strings
Use case: when running a process that populates many inherited tables across schemas, having one fail gives the unhelpful error message: ERROR: invalid input syntax for integer: "abc" CONTEXT: COPY foo, line 1, column a: "abc" Unhelpful because "foo" does not uniquely identifies the table or statement in... 2 May 2010 12:03

[HACKERS] TOAST code ignores freespace (was Tweak TOAST code)
On Wed, 2009-07-22 at 01:21 +0000, Tom Lane wrote: Tweak TOAST code so that columns marked with MAIN storage strategy are not forced out-of-line unless that is necessary to make the row fit on a page. Previously, they were forced out-of-line if needed to get the row down to the default target size (1/4th... 2 May 2010 09:50

[HACKERS] Further Hot Standby documentation required
Recent changes to parameters aren't yet sufficiently well documented and I'd like to see this improved by the authors of those patches. I accept the behaviour changes, but we need full docs to explain them. * hot_standby doesn't mention that wal_level = hot_standby is also required, nor is there a xref. * wa... 2 May 2010 07:40

[HACKERS] XML Todo List
Hackers, I'm interested in tackling some of the todo items in XML category. Being new to postgres hacking I'm hoping I chose an item that isn't more than I can chew in the first sitting. One item that has caught my eye that I (naively) hope isn't a huge todo is: xpath_exists() is needed. It checks, whether ... 2 May 2010 07:40

Protecting against case where shmget says EINVAL instead of EEXIST
On Sat, May 1, 2010 at 12:01 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: The thread here http://archives.postgresql.org/pgsql-admin/2010-04/msg00358.php shows that current OS X contains the same issue that was complained of a year or so ago with respect to NetBSD.  Namely, that if shmget finds an existing sh... 1 May 2010 13:11