PgSql

[HACKERS] Call for translations
In anticipation of the release of PostgreSQL 9.0, it is once again time to update the message translations. We are not very near a string freeze yet, which has traditionally been associated with the first release candidate, but I feel that things are already stable enough to begin this work now. If you want to ... 19 Mar 2010 16:39

[HACKERS] Repeating Append operation
Hi all, explain select v from ( select array( select 1 union all select 2) as v from (select 1) ) as s where v is not null; The plan looks like: QUERY PLAN -------------------------------------------------------- Result (cost=0.08..0.10 rows=1 width=0) ... 19 Mar 2010 14:22

[HACKERS] Postgres officially accepted in to 2010 Google Summer of Code program
Howdy folks, I'm very happy to announce that the Postgres project has been selected to participate in this years Google Summer of Code program. Over the next couple weeks we'll be looking to solidify our mentor base; if you work on Postgres and would be willing to mentor a student, please send me a note so ... 19 Mar 2010 13:12

pgsql: Reset btpo.xact following recovery ofbtree delete page.
On Fri, 2010-03-19 at 08:41 -0400, Tom Lane wrote: sriggs(a)postgresql.org (Simon Riggs) writes: Log Message: ----------- Reset btpo.xact following recovery of btree delete page. Add btpo_xact field into WAL record and reset it from there, rather than using FrozenTransactionId which can lead t... 19 Mar 2010 12:00

Command to prune archive at restartpoints
Committed. Heikki Linnakangas wrote: One awkward omission in the new built-in standby mode, mainly used for streaming replication, is that there is no easy way to delete old archived files like you do with the %r parameter to restore_command. This was discussed at http://archives.postgresql.org/pgsql-... 22 Mar 2010 13:05

Order of pg_stat_activity timestamp columns
On Wed, Mar 17, 2010 at 21:42, Bruce Momjian <bruce(a)momjian.us> wrote: Has anyone ever noticed that the order of pg_stat_activity timestamp columns is illogical:  xact_start       | timestamp with time zone |  query_start      | timestamp with time zone |  backend_start    | timestamp with time zone |... 17 Mar 2010 21:12

[HACKERS] Order of pg_stat_activity timestamp columns
Has anyone ever noticed that the order of pg_stat_activity timestamp columns is illogical: xact_start | timestamp with time zone | query_start | timestamp with time zone | backend_start | timestamp with time zone | query_start is always between the other two timestamps. Moving query_start be... 17 Mar 2010 17:24

PQftype implementation
Pavel Golub <pavel(a)microolap.com> writes: Here I created user-defined type "my_varchar" for internal tests. But PQftype returns 1043 (varchar oid) for the "info" column. Really? I tried it and got 172069, which is about right for where the OID counter is in my database. I think you messed up your test. ... 18 Mar 2010 04:50

pgsql: Make standby server continuouslyretry restoring the next WAL
Fujii Masao wrote: I found another missing feature in new file-based log shipping (i.e., standby_mode is enabled and 'cp' is used as restore_command). After the trigger file is found, the startup process with pg_standby tries to replay all of the WAL files in both pg_xlog and the archive. So, when th... 30 Mar 2010 13:52

parametrized NOTIFY - issue in plpgsql, maybe ToDo
Pavel Stehule <pavel.stehule(a)gmail.com> writes: I am testing NOTIFY statement. It have to be used from plpgsql via EXECUTE, because doesn't support paramaters. Can be it documented somewhere? It is. Use the function instead. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hacke... 16 Mar 2010 16:15