REFERENCES Constraint

From: Pavel Fryc <Pavel(dot)Fryc(at)oskarmobil(dot)cz>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Cc: Borek Lupomesky <Borek(dot)Lupomesky(at)oskarmobil(dot)cz>
Subject: REFERENCES Constraint
Date: 2001-07-18 15:27:53
Message-ID: 11CCE9D433CFD311B32A00508B95BCA004F0C6FE@wh01ex02.ceskymobil.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there a way to find out for given row and column what other tables/rows
reference this row/column by means of reference integrity. I need this when
user deletes number of rows from a table and there is integrity violation I
want to get a list of tables/rows that cause the violation for user to
review.
I need help from You with this my problem.

Best regards, Pavel Fryc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrice Scemama 2001-07-18 15:39:15 Re: VACUUM ANALYZE
Previous Message Ryan C. Bonham 2001-07-18 15:21:17 RE: THIS IS NOT RELATED TO THE RDBMS BUT PLEEEEEEEEEEEE EASE