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