PgSql

Reading deleted records - PageHeader v3
"Jonathan Bond-Caron" <jbondc(a)gmail.com> writes: I think part of my problem is I haven't really understood what 'Then make sure you have the right alignment' means. My approach currently is: After reading HeapTupleHeaderData (23 bytes), I advance another 4 bytes (hoff) and try to read a 32 bit integ... 8 Feb 2010 19:07

Add on_plperl_init and on_plperlu_init to plperl UPDATE 3 [PATCH]
On Fri, Feb 5, 2010 at 06:40, Tim Bunce <Tim.Bunce(a)pobox.com> wrote: This is the third update to the fourth of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Added plperl.on_plperl_init and plperl.on_plperlu_init GUCs    Both are PGC_SUSET    S... 6 Feb 2010 07:29

WIP patch for system-catalog vacuuming via a relationmap
Barring objections I'm going to press ahead with completing and committing this; then in a separate patch remove VACUUM FULL INPLACE. Was it our determination that we could remove VFI if we eliminated the system catalogs? I'm fine with it, I just thought some people had a marginal use case for VFI. --Jo... 6 Feb 2010 07:29

Confusion over Python drivers
On Friday 05 February 2010 21:34:53 Marko Kreen wrote: On 2/5/10, Josh Berkus <josh(a)agliodbs.com> wrote: I think another difference is that the Perl DBI interface is very rich, whereas the Python DB-API is quite minimal and almost forces people to write (incompatible) extensions. The DB-SIG ... 15 Feb 2010 23:20

Writeable CTEs patch
Marko Tiikkaja <marko.tiikkaja(a)cs.helsinki.fi> wrote: Here's an updated patch. Only changes from the previous patch are fixing the above issue and a regression test for it. A brief report for of the patch: * The patch has the following error cases, and also have one regression test for each case. ... 9 Feb 2010 18:34

[HACKERS] pg_class has no toast table?
Still fooling with VACUUM FULL on catalogs ... I find that a sanity check I put in is barfing on "VACUUM FULL pg_class", because the transient table is built with a toast table, whereas pg_class hasn't got one. It seems like it probably ought to have one, because either relacl or reloptions could in principle be t... 4 Feb 2010 19:07

[HACKERS] proposed PQconnectdbParams macros (was Re: [BUGS] BUG #5304: psqlusing conninfo fails in connecting to the server)
[moving to hackers] On 02/02/2010 10:23 PM, Tom Lane wrote: Joe Conway <mail(a)joeconway.com> writes: Should I also be looking to replace all (or most) other instances of PQsetdbLogin()? I think we at least wanted to fix pg_dump(all)/pg_restore. Not sure if the others are worth troubling over. ... 3 Feb 2010 19:41

[HACKERS] testing cvs HEAD - HS/SR - cannot stat
Hello, Testing 9.0devel HS/SR: I used cvs HEAD (today) with the new_smart_shutdown_20100201.patch of Fujii Masao. Replication works well. The slave can be stopped and restarted. However, whenever (re-)starting the slave the I get messages like: cp: cannot stat `/var/data1/pg_stuff/dump/replication_archiv... 3 Feb 2010 17:25

[HACKERS] use of dblink_build_sql_insert() induces a server crash
Hi All, Testcase: create table foo (a int ); postgres=# SELECT dblink_build_sql_insert('foo','1 2',2,'{\"0\", \"a\"}','{\"99\", \"xyz\"}'); HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. server closed the connection unexpectedly This probably means the server terminated abnormally ... 3 Feb 2010 14:01

[COMMITTERS] pgsql: Assorted cleanups in preparation for using a map file to support
Simon Riggs <simon(a)2ndQuadrant.com> writes: On Wed, 2010-02-03 at 01:14 +0000, Tom Lane wrote: 1. Get rid of inval.c's dependency on relfilenode, by not having it emit smgr invalidations as a result of relcache flushes. Instead, smgr sinval messages are sent directly from smgr.c when an actual relation ... 3 Feb 2010 14:01