Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group