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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done
Дата
Msg-id CAB7nPqR5mpKM6HWh1jE9crWa-8mjri_J9exD3AyYuEEnW0cTQg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done
Список pgsql-bugs
Дерево обсуждения


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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: BUG #11671: UNACCENT call with constant arg evaluated for each row
Следующее
От: Casey & Gina
Дата:
Сообщение: Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done