Horton

Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done

Michael Paquier <michael.paquier@gmail.com>

View thread
From: Michael Paquier <michael.paquier@gmail.com>
To: Andres Freund <andres@2ndquadrant.com>
Cc: cg@osss.net, pgsql-bugs@postgresql.org
Date: 2014-10-15T08:31:54Z
Lists: pgsql-bugs

Attachments

On Wed, Oct 15, 2014 at 3:18 PM, Andres Freund <andres@2ndquadrant.com>
wrote:

> On 2014-10-15 15:02:43 +0900, Michael Paquier wrote:
> > Btw, I have just put my hands on this code and made the attached to
> > make vac_update_relstats able to do a transactional update. It looks
> > to work fine with only a check on the flags of vacuum statement.
>
> Have you tested that the problem's now fixed?
>
Yep. In the test case given by Casey the foreign key on the second table is
visible after the rollback.


> Imo this is complex enough to deserve a regression test. Can you add
> one?
>
Definitely makes sense. Here is an updated version.
Regards,
-- 
Michael