Re: constraint deferred but fails?
От
David G. Johnston
Тема
Re: constraint deferred but fails?
Дата
Msg-id
CAKFQuwY10pL1i+z2N62Rm8wMpYvMJrNHL=igcR_O65KiCqKPsQ@mail.gmail.com
Ответ на
Re: constraint deferred but fails? (Nagy László Zsolt)
Список
Дерево обсуждения
constraint deferred but fails? Nagy László Zsolt <gandalf@shopzeus.com>
Re: constraint deferred but fails? Shreeyansh Dba <shreeyansh2014@gmail.com>
Re: constraint deferred but fails? "David G. Johnston" <david.g.johnston@gmail.com>
Re: constraint deferred but fails? Nagy László Zsolt <gandalf@shopzeus.com>
Re: constraint deferred but fails? "David G. Johnston" <david.g.johnston@gmail.com>
Re: constraint deferred but fails? Ron <ronljohnsonjr@gmail.com>
Please don’t top-post replies on these lists.
It is already deferrable:
ALTER TABLE doc.book ADD CONSTRAINT fk_book_display_mode_id FOREIGN KEY (display_mode_id) REFERENCES doc.display_mode(id) DEFERRABLE
Ignoring the question of why you want to do things this way it seems you need to provide a self-contained, complete, test case to get a sound answer. Though I suspect it may have to do with an on delete clause you haven’t shown.
David J.
В списке pgsql-admin по дате отправления
