Re: how to know which object depend of it? - Mailing list pgsql-novice

From Tom Lane
Subject Re: how to know which object depend of it?
Date
Msg-id 28869.1107359374@sss.pgh.pa.us
Whole thread Raw
In response to how to know which object depend of it?  (Akbar <melinda_sayang@hotpop.com>)
List pgsql-novice
Akbar <melinda_sayang@hotpop.com> writes:
> I try to drop some constraint.... it said ERROR: cannot drop constraint
> blablabla on table blablabla because other object depend on it...
> HINT: blablabla

> How do I know which object depend on this constraint?

Read the NOTICEs that came out just before the ERROR.  (If you are using
client software that drops NOTICE messages on the floor, use something
else.)

            regards, tom lane

pgsql-novice by date:

Previous
From: Mitch Pirtle
Date:
Subject: Re: some help
Next
From: Bruce Momjian
Date:
Subject: Re: Last ID Problem