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

how to check objects dependency??

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to check objects dependency??
Date: 2007-10-31 14:50:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I am trying to drop a user but it complained with the following message:

ERROR:  role "joe" cannot be dropped because some objects depend on it
DETAIL:  1 objects in database Jan_test
1 objects in database Jan

this user does not own any tables in those two databases. Is there any command I can use to check all the dependencies on this user?


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


pgsql-admin by date

Next:From: Scott MarloweDate: 2007-10-31 15:07:16
Subject: Re: Postgresql Database Corrupted
Previous:From: Scott MarloweDate: 2007-10-31 14:42:13
Subject: Re: Find who is connected to a database

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