Tomasz Misterka writes:
> namebase=# \z
> Access permissions for database "namebase"
> Relation | Access permissions
> ----------+-------------------------------------------
> dbsx1 | {"=","1118=r","user2=arw","user3=r"}
> dbsx2 | {"=","1118=r","user2=arw","user3=r"}
>
>
> 1118 is a result of deleting user "user1" - this time it's oly read
> permission, but how to clean that?
Recreate a user with the same id and clean up the permissions.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter