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: (view raw, whole thread or download thread mbox)
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

			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-2017 The PostgreSQL Global Development Group