> From: Alessandro Aste <alessandro.a...@gmail.com> > Sent: Saturday, August 4, 2018 12:02 AM > To: Ertan Küçükoğlu <ertan.kucuko...@1nar.com.tr> > Cc: pgsql-gene...@postgresql.org > Subject: Re: Eror while dropping a user > > You can run this query to itendify the relations owned by the users you're > not allowed to drop, > just replace ('<your_user_name_to_check>', 'username2' ..'userN' ) with > the your role names . > Then, once you have identified the tables/objecst change the owner like > this:
I tried to run it on "postgres" database and "pars" database, schemas on pars database, etc. All return empty results. Thanks anyway. Regards, Ertan