I would like to alter a FK constraint to be "deferrable initially deferred". I've looked on web for an "alter table"-script to accomplish this, without success. Does anybody here know how to do this without dropping the constraint and re-creating it again?
You cannot alter a constraint's deferrability. That is, whether you specify either of these parameters, or make the constraint NOT DEFERRABLE implicitly by specifying neither of them, you cannot specify this clause in an ALTER TABLE statement. You must drop the constraint and re-create it.