Обсуждение: Exactly what is DEFERRABLE

Поиск
Список
Период
Сортировка

Exactly what is DEFERRABLE

От
Richard Broersma Jr
Дата:
I noticed from the 8.3 manual (CREATE TABLE section):

NOT DEFERRABLE
... Only foreign key constraints currently accept this clause. All other constraint types are not deferrable.

Does this imply that custom CONSTRAINT TRIGGERs are not DEFERRABLE? Or are they?

Regards,
Richard Broersma Jr.

Re: Exactly what is DEFERRABLE

От
Richard Broersma Jr
Дата:
--- On Fri, 12/21/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> Does this imply that custom CONSTRAINT TRIGGERs are not
> DEFERRABLE? Or are they?

Sorry dumb question.  They must be deferrable since their create statement allows for differable.

Regard,s
Richard Broersma Jr.