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