Postgres Pro
Downloads
Home   >   mailing lists

Re: how to check objects dependency?? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to check objects dependency??
Date
Msg-id 29585.1194016502@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to check objects dependency??  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
Tree view 
Jessica Richard <rjessil@yahoo.com> writes:
> I am sure in the future there will be times that I need to check the ownership of the functions but not allowed to
dropusers to see check the dependencies. 

There's no need for a separate operation for that.  Do

    begin;
    drop user foo;
    rollback;

            regards, tom lane

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: How do I identify the privileges a role has?
Next
From: "Peter Childs"
Date:
Subject: Re: jumpstart - pgsql.v824