Dear Tom!
Is there any tool what can show me the dependents or dependencies?
In PGAdmin I don't see any dependencies or dependents... :-(
Thanks
dd
2016-10-21 16:08 GMT+02:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Durumdara <durumdara(at)gmail(dot)com> writes:
> > The DB_X dropped, so I can't choose it as "actual database".
> > I tried this in a neutral database:
> > drop owned by role_x;
> > But nothing happened, the error is same.
>
> The error you are reporting is describing default privileges that
> exist in the *current* database. You need to do DROP OWNED BY
> in that database (and maybe other ones, but start there).
>
> regards, tom lane
>