[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Re: [BUGS] BUG #11638: Transaction safety fails when constraints are dropped and analyze is done
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2014-10-29 22:15:59
Message-ID: 26019.1414620959 () sss ! pgh ! pa ! us
[Download RAW message or body]
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic