Cannot remove prepared statement.

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 inherited tables then the session crashes.
I am using partitioned constraints on this table. tried turning off in conf didn't help

If I restore from backup the session crashes
I cannot delete the database as it says there are prepared statements.

I have restarted postgres, tried to set prepared statements back to 0 but then postgres will not start.
Logs tell me to Set max_prepared_transactions to a nonzero value.

Rebooted server many times.
All other databases work fine.
I am using 8.4

"doc, you gotta help us, man - we've tried nothing and were all out of ideas"

Regards,
Darryl

_________________________________________________________________
Looking for a place to rent, share or buy? Find your next place with ninemsn Property
http://clk.atdmt.com/NMN/go/157631292/direct/01/