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

From graeme
Subject Re: how to know which object depend of it?
Date
Msg-id 4200C2E2.7050205@sherubtse.edu.bt
Whole thread Raw
In response to how to know which object depend of it?  (Akbar <melinda_sayang@hotpop.com>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: Hasnul Fadhly bin Hasan
Date:
Subject: Accessing insert values in triggers
Next
From: "William Dominguez"
Date:
Subject: some help