Re: how to know which object depend of it?

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