RE: Eror while dropping a user

From: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RE: Eror while dropping a user
Date: 2018-08-03 21:33:12
Message-ID: 001201d42b71$951cabd0$bf560370$@1nar.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: Alessandro Aste <alessandro(dot)aste(at)gmail(dot)com>
> Sent: Saturday, August 4, 2018 12:02 AM
> To: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
> Cc: pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ertan Küçükoğlu 2018-08-03 21:46:26 RE: Eror while dropping a user
Previous Message Michael Paquier 2018-08-03 21:04:27 Re: Sv: WAL-dir filling up with wal_level = logical