From: | Darryl Pye <darrylpye(at)hotmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Cannot remove prepared statement. |
Date: | 2010-03-01 10:19:31 |
Message-ID: | COL109-W43EE57FE787503F9CB357CB33C0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2010-03-01 11:00:15 | Re: [GENERAL] trouble with to_char('L') |
Previous Message | Adrian von Bidder | 2010-03-01 09:51:00 | Re: continuous copy/update one table to another |