Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot remove prepared statement. - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot remove prepared statement.
Date
Msg-id 18049.1267460480@sss.pgh.pa.us
Whole thread Raw
In response to Cannot remove prepared statement.  (Darryl Pye <darrylpye@hotmail.com>)
List pgsql-general
Tree view 
Darryl Pye <darrylpye@hotmail.com> writes:
> I am having some problems with prepared statements.
> Somehow I have 2  orphan prepared statements in one of my databases.

I think you are confusing prepared statements with prepared
transactions.

> I have tried Deallocate All and  Discard All,  no joy.

ROLLBACK PREPARED is probably the command you're looking for.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimizer: ranges and partial indices? Or use partitioning?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Cacti + PostgreSQL Graphing