Re: AFTER triggers and constraints

Поиск

Список

Период

Сортировка

От	Vick Khera
Тема	Re: AFTER triggers and constraints
Дата	28 июня 2013 г. 16:35:01
Msg-id	CALd+dccFb0EkVUfKxcqwn1fTk6uaWHrdnC3pDi1AeEVfQh_CLQ@mail.gmail.com обсуждение исходный текст
Ответ на	AFTER triggers and constraints (David Greco <David_Greco@harte-hanks.com>)
Ответы	Re: AFTER triggers and constraints (David Greco <David_Greco@harte-hanks.com>)
Список	pgsql-general

On Fri, Jun 28, 2013 at 8:45 AM, David Greco <David_Greco@harte-hanks.com> wrote:

The last delete statement will throw a referential integrity error. In Oracle, same example, it does not as the trigger deletes the child.

Not sure your real case, but why not just make the FK on delete cascade and get rid of your trigger entirely?

Alternatively, what if you make your constratint initially deferred?

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

От: Christoph Berg
Дата: 28 июня 2013 г., 16:09:47
Сообщение: Re: Why are there no inequality scans for ctid?

От: David Greco
Дата: 28 июня 2013 г., 16:38:02
Сообщение: Re: AFTER triggers and constraints