Constraint question

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...

Responses

Browse pgsql-admin by date

  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.