Re: how to know which object depend of it?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 15:49:34
Message-ID: 28869.1107359374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Akbar <melinda_sayang(at)hotpop(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Akbar 2005-02-02 16:40:01 how to know which object depend of it?
Previous Message Mitch Pirtle 2005-02-02 15:23:59 Re: some help