Postgres Pro
Downloads
Home   >   mailing lists

how to get dependancies of a table? - Mailing list pgsql-novice

From nobs@nobswolf.info (Emil Obermayr)
Subject how to get dependancies of a table?
Date
Msg-id 20080707081801.GB4029@nobswolf.info
Whole thread Raw
Responses Re: how to get dependancies of a table?
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: Miernik
Date:
Subject: how to create a function in plpgsql which picks the name of a variable which is NULL out of a list of variables?
Next
From: Tom Lane
Date:
Subject: Re: how to get dependancies of a table?