Thread: Exactly what is DEFERRABLE

Exactly what is DEFERRABLE

From
Richard Broersma Jr
Date:
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

From
Richard Broersma Jr
Date:
--- 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.