how to know which object depend of it?

From: Akbar <melinda_sayang(at)hotpop(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to know which object depend of it?
Date: 2005-02-02 16:40:01
Message-ID: 1107362401.11226.1.camel@tux.akbarhome
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2005-02-02 17:26:32 Re: [NOVICE] Last ID Problem
Previous Message Tom Lane 2005-02-02 15:49:34 Re: how to know which object depend of it?