Postgres Pro
Downloads
Home   >   mailing lists

Re: REVOKE to an user that doesn't exist - Mailing list pgsql-general

From Moreno Andreo
Subject Re: REVOKE to an user that doesn't exist
Date
Msg-id 2f1b90d6-9868-96fa-ab2e-1bb8713b52f2@evolu-s.it
Whole thread Raw
In response to Re: REVOKE to an user that doesn't exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Il 12/12/2018 16:01, Tom Lane ha scritto:
>
> The safest way to clean it up manually would be to set the pg_proc.proacl
> field for that function to NULL.  If there are other grants about the
> function, you could try removing the bad entry, but it would likely be
> safer to just re-grant after the upgrade.
>
Setting the column (and several others from other tables such as 
pg_class) to null made me possible to upgrade the cluster. After the 
upgrade, I issued the necessary GRANTs and everything is up & running on 
Postgres 10 now!

Thanks again

Moreno.-

pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: conditionally terminate psql script
Next
From: "Daniel Verite"
Date:
Subject: Re: Creating 2D arrays for pg_copy_from, reading tab-delimted textfile that contains comma and double quotes