From: | Enzo Daddario <enzo(at)pienetworks(dot)com> |
---|---|
To: | PGADMIN <pgsql-admin(at)postgresql(dot)org> |
Subject: | Constraint question |
Date: | 2006-05-15 02:19:16 |
Message-ID: | 1147659556.29084.26.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
I am currently using Postgres 8.1.2 and am in the process
of restructuring our entire DB.
The current structure - table "X" is the central/main table in the DB
and has approx 100 tables which reference it in the form of foreign key
constaints.
I am now required the remove thousands of obsolete records from table
"X" and even though I have removed all related rows in all related
tables, the deletion of rows in table "X" is taking WAY TOO LONG. I am
assuming that this is because the deletion of each row in table "X"
requires that all the related tables(a number of them are huge) need to
be first checked.
Is there a way I can temporarily disable this checking and then
re-enable it after the rows in table "X" are deleted.
Thanks ENZO...
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-15 02:50:50 | Re: Constraint question |
Previous Message | Andy Shellam | 2006-05-14 11:28:20 | Re: install postgre on windows XP, service failed to start. |