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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--- 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.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend