Thursday, October 20, 2011

drop role denied in postgres

Using postgres, I intended to drop the role 'paponte', but encountered the error:
# drop role paponte;
ERROR: role "paponte" cannot be dropped because some objects depend on it
DETAIL: 4 objects in database admision

Following (http://stackoverflow.com/questions/3023583/postgresql-how-to-quickly-drop-a-user-with-existing-privileges)

I did
# drop owned by paponte;
DROP OWNED

And then no problem with:
# drop role paponte;
DROP ROLE

No comments:

Post a Comment

cancel script completely on ctrl-c

I found this question interesting: basically how to cancel completely a script and all child processes : You do this by creating a subro...