Re: PREPARE and transactions - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: PREPARE and transactions
Date
Msg-id 40DA2FCA.9060203@familyhealth.com.au
Whole thread Raw
In response to Re: PREPARE and transactions  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: PREPARE and transactions  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: PREPARE and transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> Part of the problem is that PREPARE has no provision to overwrite an
> existing plan (CREATE OR REPLACE).  I run into this all the time because
> I make heavy use of prepared statements to emulate an ISAM file system.
> I have to jump through hoops to keep track of what statements are
> already prepared to keep from bouncing the current transaction.

Bruce - TODO?:

* PREPARE OR REPLACE...

This would be an incredibly useful command since there's no way of 
_checking_ in advance that a name is already used as a prepared statement...

Chris



pgsql-hackers by date:

Previous
From: markw@osdl.org
Date:
Subject: DBT-2 results using tablespaces
Next
From: Christopher Kings-Lynne
Date:
Subject: pg_largeobject and tablespaces