Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: cg@osss.net
Cc: pgsql-bugs@postgresql.org
Date: 2014-10-29T22:15:59Z
Lists: pgsql-bugs
cg@osss.net writes: > When, within a transaction: > * I drop a foreign key (or any) constraint. > * Load some data to the table which won't fit the constraint. > * Analyze the table. > * Attempt to re-add the constraint which fails and should roll back the > whole transaction. > The constraint is still missing after rollback. > If I take out the analyze step, it works as expected. Fix committed, many thanks for chasing this down to the point of having a reproducible case! I imagine this was a real bear to pinpoint. regards, tom lane