From: | graeme <graeme_foster(at)sherubtse(dot)edu(dot)bt> |
---|---|
To: | Akbar <melinda_sayang(at)hotpop(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: how to know which object depend of it? |
Date: | 2005-02-02 12:09:06 |
Message-ID: | 4200C2E2.7050205@sherubtse.edu.bt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Rodolfo J. Paiz | 2005-02-02 14:57:50 | Re: some help |
Previous Message | Jeremiah Knoche | 2005-02-02 10:53:53 | Batch Insert tables |