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

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

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] 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 get there,

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

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] 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 another

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, in the

[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

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 tree