[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. ***

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 offsets

[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

[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

[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

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 few

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: [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

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 control

[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

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 prefer

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

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

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

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 a -L

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 an error that's

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?

[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: [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...

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

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:

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

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. Also, there was

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 why

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, I'll

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 time, to

[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 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 value as was