Re: Cannot remove prepared statement.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darryl Pye <darrylpye(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot remove prepared statement.
Date: 2010-03-01 16:21:20
Message-ID: 18049.1267460480@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darryl Pye <darrylpye(at)hotmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2010-03-01 18:43:46 Re: Cacti + PostgreSQL Graphing
Previous Message Tom Lane 2010-03-01 16:04:46 Re: Optimizer: ranges and partial indices? Or use partitioning?