[PATCHES] Patch for UUID datatype (beta)

2006-09-17 Thread Gevik Babakhani
Folks, The following patch implements the UUID datatype. I would like to send this beta patch to see if I still am on the right track. Please send your comments. Description of UUID: - The type is called uuid. - btree and hash indexes are supported. - uuid array is supported. - uuid text i/o is

Re: [PATCHES] tiny patch to make vacuumdb -a's database order match pg_dumpall

2006-09-17 Thread Dan Thomas
Um, whaddya mean "dumpall was getting stuck behind vacuum's lock"? A plain vacuum doesn't take any locks that would block pg_dump. Dammit, just looked and the setup I originally encountered the problem on and tracked it down to the vacuum process, and it is indeed set up to perform a full vacuum

Re: [PATCHES] tiny patch to make vacuumdb -a's database order match pg_dumpall

2006-09-17 Thread Tom Lane
"Dan Thomas" <[EMAIL PROTECTED]> writes: > I've been having trouble running vacuumdb -a and pg_dumpall > concurrently because they run through the databases in a different > order (so dumpall was getting stuck behind vacuum's lock, and my > firewall was rather unhelpfully closing the idle connectio

Re: [PATCHES] [HACKERS] Timezone List

2006-09-17 Thread Joachim Wieland
On Sat, Sep 16, 2006 at 04:19:48PM -0400, Tom Lane wrote: > I've applied this along with some extra work to get it to show GMT > offsets and DST status, which should be useful for helping people > to choose which setting they want. This effectively obsoletes > Table B-5 as well as B-4 in the SGML