May 2018
Intermediate to advanced
576 pages
30h 25m
English
When trying to drop a user who owns some tables or other database objects, you get the following error, and the user is not dropped:
testdb=# drop user bob;ERROR: role “bob” cannot be dropped because some objects depend on itDETAIL: owner of table bobstableowner of sequence bobstable_id_seq
This recipe presents two solutions to this problem.