Re: Triggers for FK on Views - can they be made deferrable?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Triggers for FK on Views - can they be made deferrable?
Дата
Msg-id 3FE71BB5.1080809@Yahoo.com
обсуждение исходный текст
Ответ на Triggers for FK on Views - can they be made deferrable?  ("ezra epstein" <ee_newsgroup_post@prajnait.com>)
Список pgsql-general
There is a way to create them as CONSTRAINT triggers. It's totally
non-standard, not guaranteed to exist in future releases, yadda, yadda.
But it get's you where you want to be now().


Jan

ezra epstein wrote:

> I've got the case of a table which has unusual FK constraints.  I'm
> implementing them as triggers against a view.  It all works, BUT I don't see
> a way to make the triggers executed only on Commit -- i.e., I'd like the
> same "deferrable" behavior that true FKs provide.  Does anyone know how to
> do this?
>
> Thanks,
>
> Ezra E.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FEATURE REQUEST: let arrays support null values.
Следующее
От: Steven D.Arnold
Дата:
Сообщение: Re: bug in query planning?