Re: PREPARE and transactions

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PREPARE and transactions
Date: 2004-06-24 01:35:06
Message-ID: 40DA2FCA.9060203@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-06-24 01:45:43 pg_largeobject and tablespaces
Previous Message Alvaro Herrera 2004-06-24 01:05:26 Re: nested xacts and phantom Xids