Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-19 Thread mark
On Tue, Sep 19, 2006 at 11:21:51PM -0400, Alvaro Herrera wrote: > [EMAIL PROTECTED] wrote: > > On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote: > > > On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: > > > > I would not use a 100% random number generator for a UUID val

[PATCHES] Fwd: docs for advisory locks

2006-09-19 Thread Merlin Moncure
[resending this to the list, was silently dropped this afternoon?] -- Forwarded message -- From: Merlin Moncure <[EMAIL PROTECTED]> Date: Sep 19, 2006 11:57 PM Subject: docs for advisory locks To: pgsql-patches@postgresql.org ok, here is the promised docs for the advisory locks.

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-19 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote: > > On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: > > > I would not use a 100% random number generator for a UUID value as was > > > suggested. I prefer inserting the MAC address and the ti

Re: [PATCHES] Dynamic linking on AIX

2006-09-19 Thread Bruce Momjian
Great, I have added this to the bottom of the AIX FAQ. Thanks. --- Albe Laurenz wrote: > > I still would like to see a paragraph describing how AIX is different > > from other platforms and what we are doing here. > > Ok,

Re: [PATCHES] More doc patches

2006-09-19 Thread Gregory Stark
Neil Conway <[EMAIL PROTECTED]> writes: > BTW, I personally prefer patches to be proper MIME attachments, created > as a patch against the root of the Postgres source tree. However, I'm > not sure what the other committers prefer. Good to know. I usually generate diffs with cvs -c. I don't know

Re: [PATCHES] More doc patches

2006-09-19 Thread Bruce Momjian
Neil Conway wrote: > On Tue, 2006-09-19 at 10:44 +0100, Gregory Stark wrote: > > Some more doc patches for partitioned tables. In particular replace the > > caveat > > that INCLUDING CONSTRAINTS doesn't exist and replace it with documentation > > of, > > well, INCLUDING CONSTRAINTS. > > > > Als

Re: [PATCHES] More doc patches

2006-09-19 Thread Neil Conway
On Tue, 2006-09-19 at 10:44 +0100, Gregory Stark wrote: > Some more doc patches for partitioned tables. In particular replace the caveat > that INCLUDING CONSTRAINTS doesn't exist and replace it with documentation of, > well, INCLUDING CONSTRAINTS. > > Also, there was an instance of "LIKE WITH DE

Re: [PATCHES] Notes on restoring a backup with --single-transaction

2006-09-19 Thread Neil Conway
On Tue, 2006-09-19 at 13:00 +0100, Simon Riggs wrote: > Additional notes for pg_dump/restore Applied with additional fixes; revised patch is attached. Thanks for the patch. -Neil Index: doc/src/sgml/backup.sgml === RCS file: /home/

Re: [HACKERS] [PATCHES] DOC: catalog.sgml

2006-09-19 Thread Zdenek Kotala
Alvaro Herrera wrote: Tom Lane wrote: Zdenek Kotala <[EMAIL PROTECTED]> writes: I little bit enhanced overview catalog tables. I added two new columns. First one is OID of catalog table and second one contains attributes which determine if the table is bootstrap, with oid and global. Why is t

Re: [PATCHES] Incrementally Updated Backup

2006-09-19 Thread Bruce Momjian
No, too late. --- Simon Riggs wrote: > > Way past feature freeze, but this small change allows a powerful new > feature utilising the Restartable Recovery capability. Very useful for > very large database backups... > > I

[PATCHES] docs for advisory locks

2006-09-19 Thread Merlin Moncure
ok, here is the promised docs for the advisory locks. some quick notes here: this is my first non trivial patch (albeit only documentation) and i am a complete docbook novice. i also dont have the capability to build docbook at the moment. so consider this a very rough draft. any comments are

Re: [HACKERS] [PATCHES] DOC: catalog.sgml

2006-09-19 Thread Zdenek Kotala
Tom Lane napsal(a): Zdenek Kotala <[EMAIL PROTECTED]> writes: I little bit enhanced overview catalog tables. I added two new columns. First one is OID of catalog table and second one contains attributes which determine if the table is bootstrap, with oid and global. Why is this a good idea?

Re: [PATCHES] [HACKERS] Incrementally Updated Backup

2006-09-19 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Simon Riggs wrote: >> + >> + if (startupAfterRecovery) >> + ereport(ERROR, >> + (errmsg("recovery ends normally with startup_after_recovery=false"))); >> + > I find this part of the patch a bit ugly. Isn't there a better way to > exit than throwing

Re: [PATCHES] Dynamic linking on AIX

2006-09-19 Thread Tom Lane
"Albe Laurenz" <[EMAIL PROTECTED]> writes: > This is a second try; this patch replaces > http://archives.postgresql.org/pgsql-patches/2006-09/msg00185.php Looks good, applied. > The line in src/makefiles/Makefile.aix > where I set 'libpath' also seems pretty ugly to me. > It will fail if there is

Re: [PATCHES] Small additions and typos on backup

2006-09-19 Thread Neil Conway
On Tue, 2006-09-19 at 11:09 +0100, Simon Riggs wrote: > In SGML, diff -c format Applied, thanks. (I'll also apply the single-transaction doc patch later today if no one beats me to it.) -Neil ---(end of broadcast)--- TIP 5: don't forget to incre

Re: [PATCHES] [HACKERS] Incrementally Updated Backup

2006-09-19 Thread Heikki Linnakangas
Simon Riggs wrote: + + if (startupAfterRecovery) + ereport(ERROR, + (errmsg("recovery ends normally with startup_after_recovery=false"))); + I find this part of the patch a bit ugly. Isn't there a better way to exit than throwing an error that's not really an error? -- Heikki Linnakangas Ent

Re: [PATCHES] Dynamic linking on AIX

2006-09-19 Thread Albe Laurenz
> I still would like to see a paragraph describing how AIX is different > from other platforms and what we are doing here. Ok, I'll try to sum it up: Shared libraries in AIX are different from shared libraries in Linux. A shared library on AIX is an 'ar' archive containing shared objects. A shar

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-19 Thread Jim C. Nasby
On Tue, Sep 19, 2006 at 09:51:23AM -0400, [EMAIL PROTECTED] wrote: > On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote: > > On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: > > > I would not use a 100% random number generator for a UUID value as was > > > suggested. I p

[PATCHES] Incrementally Updated Backup

2006-09-19 Thread Simon Riggs
Way past feature freeze, but this small change allows a powerful new feature utilising the Restartable Recovery capability. Very useful for very large database backups... Includes full documentation. Perhaps a bit rushed, but inclusion in 8.2 would be great. (Ouch, don't shout back, read the pa

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-19 Thread mark
On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote: > On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: > > I would not use a 100% random number generator for a UUID value as was > > suggested. I prefer inserting the MAC address and the time, to at > > least allow me to c

Re: [PATCHES] Dynamic linking on AIX

2006-09-19 Thread Bruce Momjian
I still would like to see a paragraph describing how AIX is different from other platforms and what we are doing here. --- Albe Laurenz wrote: > This is a second try; this patch replaces > http://archives.postgresql.org/pgsq

Re: [PATCHES] Dynamic linking on AIX

2006-09-19 Thread Albe Laurenz
This is a second try; this patch replaces http://archives.postgresql.org/pgsql-patches/2006-09/msg00185.php Incorporated are - Tom Lane's suggestions for a more sane approach at fixing Makefile.shlib - Rocco Altier's additions to make the regression test run by setting LIBPATH appropriately. -

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-19 Thread Jim C. Nasby
On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: > I would not use a 100% random number generator for a UUID value as was > suggested. I prefer inserting the MAC address and the time, to at > least allow me to control if a collision is possible. This is not easy > to do using a fe

[PATCHES] new patch for uuid datatype

2006-09-19 Thread Gevik Babakhani
Folks, I would like to submit an updated patch for the uuid datatype. I have removed the new_guid() function assuming we want a generator function in the contrib. I also have included a regression test and added the default copyright header for the new files. If this patch gets accepted then I ca

[PATCHES] Notes on restoring a backup with --single-transaction

2006-09-19 Thread Simon Riggs
Additional notes for pg_dump/restore -- Simon Riggs EnterpriseDB http://www.enterprisedb.com Index: doc/src/sgml/backup.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/backup.sgml,v retrieving revision 2.8

[PATCHES] Small additions and typos on backup

2006-09-19 Thread Simon Riggs
In SGML, diff -c format -- Simon Riggs EnterpriseDB http://www.enterprisedb.com Index: doc/src/sgml/backup.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/backup.sgml,v retrieving revision 2.86 diff -c -r2

Re: [PATCHES] [HACKERS] Timezone List

2006-09-19 Thread Joachim Wieland
On Sat, Sep 16, 2006 at 04:19:48PM -0400, Tom Lane wrote: > "Magnus Hagander" <[EMAIL PROTECTED]> writes: > > Here goes. Tested only on win32 so far, but works there. No docs yet > > either - need to know if it goes in first ;) > I've applied this along with some extra work to get it to show GMT >

[PATCHES] More doc patches

2006-09-19 Thread Gregory Stark
Some more doc patches for partitioned tables. In particular replace the caveat that INCLUDING CONSTRAINTS doesn't exist and replace it with documentation of, well, INCLUDING CONSTRAINTS. Also, there was an instance of "LIKE WITH DEFAULTS" which is actually spelled "LIKE INCLUDING DEFAULTS". ***