Hi all.
I'd need to do large updates into already populated tables as
a maintenance activity.
The updates are generated by software and are consistent with
the constraints defined in the tables.
As of now I've been looking at the index and constraint definitions,
dropping them, doing the inserts
Am Dienstag, 4. Dezember 2007 schrieb Reg Me Please:
Is there a way to suspend the index updates and the constraint checks
before the inserts in order to later re-enable them and do a reindex?
You can disable foreign-key constraints (see ALTER TABLE ... DISABLE TRIGGER;
not quite obvious, but
Il Tuesday 04 December 2007 11:50:21 Peter Eisentraut ha scritto:
Am Dienstag, 4. Dezember 2007 schrieb Reg Me Please:
Is there a way to suspend the index updates and the constraint checks
before the inserts in order to later re-enable them and do a reindex?
You can disable foreign-key
On Tue, Dec 04, 2007 at 10:09:06AM +0100, Reg Me Please wrote:
Is there a way to suspend the index updates and the constraint checks
before the inserts in order to later re-enable them and do a reindex?
You can defer foreign key checks and possibly constraints, but unique
index checks can't be