Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Дата
Msg-id 20221124222356.qolurdwwcnxkbjt2@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Список pgsql-bugs
On 2022-Nov-24, David G. Johnston wrote:

> On Thu, Nov 24, 2022 at 10:12 AM Roman Garcia <yzerno@gmail.com> wrote:
> 
> > Maybe I should have created this report as a possible evolution then ? As
> > I understand it, the whole point of deferrable initially deferred is for it
> > to be checked at transaction commit, not just for insert/update/delete, but
> > as a general concept for the constraint.
>
> I don't see any benefit for the effort making it work for DDL.

Yeah ... I agree that this scenario seems rather pointless, but I don't
see any hard argument for making it not work, other than development
effort.  If Roman or somebody would like to submit a patch to implement
it, I don't see why we wouldn't accept it (pending review process, ofc).

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Crear es tan difícil como ser libre" (Elsa Triolet)



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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Следующее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: Incorrect messages emitted from pgoutput when using column lists