On Wed, Dec 22, 2004 at 04:17:29PM +0100, Pavel Stehule wrote: > I try INITIALLY DEFERRED clause. In doc is relation between general > constraint and this clause. But combination with CHECK clause ends with > err message misplaced INITIALLY DEFERRED clause.
The CREATE TABLE documentation for INITIALLY DEFERRED says, "If a constraint is deferrable, this clause specifies the default time to check the constraint." Just above that, the documentation for DEFERRABLE says, "Only foreign key constraints currently accept this clause. All other constraint types are not deferrable." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
