Re: [PATCHES] Inherited Constraints

2005-12-13 Thread Simon Riggs
On Wed, 2005-12-07 at 21:24 +, Simon Riggs wrote: > Following patch implements record of whether a constraint is inherited > or not, and prevents dropping of inherited constraints. > > What it doesn't do: Patch withdrawn while I work on the final item. Best Regards, Simon Riggs ---

[PATCHES] psql patch: new host/port without leaving session

2005-12-13 Thread David Fetter
Folks, Please find enclosed a patch that lets you use \c to connect (optionally) to a new host and port without exiting psql. This eliminates, IMHO, a surprise in that you can now connect to PostgreSQL on a differnt machine from the one where you started your session. This should help people who

Re: [PATCHES] TODO item: list prepared queries

2005-12-13 Thread Neil Conway
On Mon, 2005-12-12 at 10:56 +0100, Joachim Wieland wrote: > I propose the attached patch for the TODO item: > > * %Allow pooled connections to list all prepared queries I think we should also return the parameters of each prepared statement. Probably the best way to do this is to add another colu

Re: [PATCHES] TODO item: list prepared queries

2005-12-13 Thread Alvaro Herrera
Neil Conway wrote: > On Mon, 2005-12-12 at 10:56 +0100, Joachim Wieland wrote: > > I propose the attached patch for the TODO item: > > > > * %Allow pooled connections to list all prepared queries > > I think we should also return the parameters of each prepared statement. > Probably the best way

Re: [PATCHES] TODO item: list prepared queries

2005-12-13 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > One minor irritation is that the query string of prepared statements > created via SQL has "PREPARE ... AS" prefixed to it, whereas statements > prepared via the FE-BE protocol do not. This should probably be fixed, That's debatable. Earlier today, I was

Re: [PATCHES] TODO item: list prepared queries

2005-12-13 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > One minor irritation is that the query string of prepared statements > created via SQL has "PREPARE ... AS" prefixed to it, whereas statements > prepared via the FE-BE protocol do not. This should probably be fixed, > but I can't see a clean way to do it: I

Re: [PATCHES] TODO item: list prepared queries

2005-12-13 Thread Michael Paesold
Tom Lane wrote: Neil Conway <[EMAIL PROTECTED]> writes: One minor irritation is that the query string of prepared statements created via SQL has "PREPARE ... AS" prefixed to it, whereas statements prepared via the FE-BE protocol do not. This should probably be fixed, but I can't see a clean way