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

how to get dependancies of a table?

From: nobs(at)nobswolf(dot)info (Emil Obermayr)
To: pgsql-novice(at)postgresql(dot)org
Subject: how to get dependancies of a table?
Date: 2008-07-07 08:18:02
Message-ID: 20080707081801.GB4029@nobswolf.info (view raw or flat)
Thread:
Lists: pgsql-novice
I want to delete a table and get the message

ERROR:  cannot drop table dummyblabla because other objects
depend on it
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

Cascading is a little bit risky so I want to avoid that.

Instead I would prefer to see the dependancies. I have no idea where to
look.

Any hints or ideas?

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-07-07 14:07:59
Subject: Re: how to get dependancies of a table?
Previous:From: MiernikDate: 2008-07-04 07:17:11
Subject: how to create a function in plpgsql which picks the name of a variable which is NULL out of a list of variables?

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