Thread: how to know which object depend of it?

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? Somebody told me
to use pg_depend... SELECT * FROM pg_depend give me headache.....

Thank you....

regards,

akbar

If you're using pgAdmin check out the "depends on" and (probably more
importantly in your case) the "referenced by" tabs.

graeme.

Akbar wrote:

>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? Somebody told me
>to use pg_depend... SELECT * FROM pg_depend give me headache.....
>
>Thank you....
>
>regards,
>
>akbar
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>

--
Experience is a good teacher, but she sends in terrific bills.

Minna Antrim

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