Re: [GENERAL] Cannot remove prepared statement.

2010-03-01 Thread Tom Lane
Darryl Pye 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

[GENERAL] Cannot remove prepared statement.

2010-03-01 Thread Darryl Pye
Hi, I am having some problems with prepared statements. Somehow I have 2 orphan prepared statements in one of my databases. I have tried Deallocate All and Discard All, no joy. If I try to change the table structures that where involved in the prepared statements or any of its inherite