Re: delete cascade question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: delete cascade question
Дата
Msg-id 13123.1165854644@sss.pgh.pa.us
обсуждение исходный текст
Ответ на delete cascade question  ("Bradley Russell" <bradley.russell@npcinternational.com>)
Список pgsql-novice
"Bradley Russell" <bradley.russell@npcinternational.com> writes:
> I'm using libpq and the PQexec function.  I am trying to figure out if I
> execute a delete query on a table that has dependent tables with on
> delete cascade set. Will the result return before or after the cascade
> is finished?

After, unless you have the constraint set to "deferred", in which case
the cascade happens at COMMIT.

            regards, tom lane

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

Предыдущее
От: "Bradley Russell"
Дата:
Сообщение: delete cascade question
Следующее
От: "Philippe Salama"
Дата:
Сообщение: Re: delete cascade question