Re: [PATCHES] WITH RECURSIVE patch V0.1

2008-05-20 Thread Kev
On May 19, 1:17 am, [EMAIL PROTECTED] (David Fetter) wrote: > On Mon, May 19, 2008 at 12:21:20AM -0400, Gregory Stark wrote: > > It's quite possible to have clauses which will limit the output but > > not in a way the database can determine. Consider for example a > > tree-traversal for a binary t

[PATCHES] LOCK_DEBUG documentation

2008-05-20 Thread Greg Sabino Mullane
Documentation patch by Kevin L. McBride explaining LOCK_DEBUG options in detail. -- Greg Sabino Mullane End Point Corporation Index: config.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.

Re: [PATCHES] Map forks (WIP)

2008-05-20 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> One thing I did *not* like was changing the FSM API to refer to Relation >> rather than RelFileNode --- I don't believe that's a good idea at all. > Oh really? I'm quite fond of the new API. From a philosophical point of > view,

Re: [PATCHES] Simplify formatting.c

2008-05-20 Thread Tom Lane
Euler Taveira de Oliveira <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Also, it seems a bit inconsistent to be relying on >> oracle_compat.c for upper/lower but not initcap. >> > I saw this inconsistence while I'm doing the patch. What about moving > that upper/lower/initcap and wcs* code to

Re: [PATCHES] Map forks (WIP)

2008-05-20 Thread Heikki Linnakangas
Tom Lane wrote: One thing I did *not* like was changing the FSM API to refer to Relation rather than RelFileNode --- I don't believe that's a good idea at all. In particular, consider what happens during TRUNCATE or CLUSTER: it's not very clear how you'll tell the versions of the relation apart.

Re: [PATCHES] Patch to change psql default banner v6

2008-05-20 Thread Guillaume Lelarge
Bryce Nesbitt a écrit : Guillaume Lelarge wrote: Here is a patch that tries to implement this. Meta-commands should work from 7.4 to 8.4-devel releases. It was not hard to do, and I don't think it really is a burden to maintain. One part left to fix is \du and \dg commands. I would be glad to

Re: [PATCHES] libpq object hooks (libpq events)

2008-05-20 Thread Merlin Moncure
On Mon, May 19, 2008 at 8:22 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew Chernow <[EMAIL PROTECTED]> writes: >> Here is an updated patch for what was called object hooks. This is now >> called libpq events. If someone has a better name or hates ours, let us >> know. > > This is starting to g

Re: [PATCHES] Patch to change psql default banner v6

2008-05-20 Thread Bryce Nesbitt
Guillaume Lelarge wrote: Here is a patch that tries to implement this. Meta-commands should work from 7.4 to 8.4-devel releases. It was not hard to do, and I don't think it really is a burden to maintain. One part left to fix is \du and \dg commands. I would be glad to continue to work on thi

Re: [PATCHES] Simplify formatting.c

2008-05-20 Thread Euler Taveira de Oliveira
Tom Lane wrote: Also, it seems a bit inconsistent to be relying on oracle_compat.c for upper/lower but not initcap. I saw this inconsistence while I'm doing the patch. What about moving that upper/lower/initcap and wcs* code to another file. pg_locale.c? BTW, formatting.c and oracle_compat.c

Re: [PATCHES] Patch for psql 8.0, 8.1 and 8.2 backwards compatibility

2008-05-20 Thread Alvaro Herrera
Bryce Nesbitt wrote: > "Ugh, I started the wrong version of psql again". > > This patch offers basic backwards compatibility, so a version 8.4 psql > can successfully do common operations on Postgres 8.0, 8.1, 8.2 and 8.3. > I expect it's incomplete support, but as of yet I can't find an actual