PgSql

Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)
Richard Huxton wrote: At present it means you can't reliably do: DROP DATABASE foo; pg_restore --create foo.dump I'd then have to either hand edit the dumpall dump or wade through a bunch of errors checking that none of them were relevant. Actually, I'm not sure pg_dumpall does them either. trac... 1 Jul 2008 04:07

Vacuuming leaked temp tables (once again)
This thread http://archives.postgresql.org/pgsql-hackers/2008-01/msg00134.php kind of wandered off into the weeds after identifying a semi-related bug in CLUSTER, but the original problem still remains: if a backend crashes after creating some temp tables, the tables remain present. Such tables will get recycled n... 12 Jul 2008 13:34

ALTER DATABASE vs pg_dump
Is it desirable that pg_dump doesn't dump config settings set via ALTER DATABASE? http://archives.postgresql.org/pgsql-novice/2008-04/msg00016.php I just got bitten by a DateStyle not being restored on my test DB (I usually set it client-side in the app). I could see someone without my steel trap of a mind ... 27 Jun 2008 12:09

VirtualXactLockTableInsert
When we move from having a virtual xid to having a real xid I don't see any attempt to re-arrange the lock queues. Surely if there are people waiting on the virtual xid, they must be moved across to wait on the actual xid? Otherwise the locking queue will not be respected because we have two things on which peopl... 30 Jun 2008 11:41

Building PostgreSQL 8.3.1 on OpenVMS 8.3 AXP
On Sat, 2008-03-22 at 22:40 +0200, Mihai Criveti wrote: I am trying to build PostgreSQL 8.3.1 on OpenVMS 8.3 Alpha, patched to UPDATE v6.0 ECO: DEC AXPVMS VMS83A_UPDATE V6.0 Patch Install Val 14-MAR-2008 Using the HP C compilers: HP C Version 7.3 for OpenVMS Alpha Systems HP ... 27 Jun 2008 04:58

Explain XML patch submitted
I just posted a patch addressing the TODO item: "Allow EXPLAIN output to be more easily processed by scripts, perhaps XML" This is a modified patch originally submitted by Germán Poó Caamaño last year. I added the DTD and some other tweaks. I did *not* delve much into the ecpg code, other than mildly modif... 27 Jun 2008 02:56

Removal of the patches email list
At 2008-06-26 18:51:46 -0400, bruce(a)momjian.us wrote: I propose we close the patches list and tell everyone to start using only the hackers list. That's an excellent idea. -- ams -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.... 27 Jun 2008 01:55

Table inheritance surprise
David Fetter wrote: Folks, When I do CREATE TABLE foo(LIKE bar INCLUDING CONSTRAINTS), it doesn't include foreign key constraints (8.3.1). I believe this is surprising behavior, but maybe not a bug, so I'd like to propose another bit of syntactic sugar, namely LIKE [INCLUDING FOREIGN KEYS... 27 Jun 2008 18:19

Join Removal/ Vertical Partitioning
Simon Riggs <simon(a)2ndquadrant.com> writes: We can check for removal of a rel by 1. inspecting the target list for the query to see if there are rels that do not provide any attributes. (We might also use equivalence classes to recode the targetlist to minimise the numbers of tables touched, but I thin... 30 Jun 2008 03:29

proposal: to_ascii(bytea)
"Pavel Stehule" <pavel.stehule(a)gmail.com> writes: Changes related to convert* functions in postgresql 8.3 has impact on to_ascii function. ISTM to_ascii has a completely bogus API anyway. What is it doing taking an encoding name as an argument? It should just assume the input text is in the database encodi... 26 Jun 2008 13:35