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
Find your next place with Ninemsn property
Looking for a place to rent, share or buy?
