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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done
Дата
Msg-id 26019.1414620959@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #11638: Transaction safety fails when constraints are dropped and analyze is done  (cg@osss.net)
Список 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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #11822: ECPG Commit or Rollback error
Следующее
От: skeefe@rdx.com
Дата:
Сообщение: BUG #11824: Postgres Restoring the same file multiple times