Revoke missing user

"Robert Fitzpatrick" <robert@webtent.com> writes:

I removed a user from PostgreSQL that had privileges on some tables, now
the access privileges shows just the former user number. When I try:
revoke all on allergies from 104;
I get:
ERROR: parser: parse error at or near "104" at character 30
I even try creating a user named 104, same result. How can I revoke
those privileges?

Create a user with the old user number:

create user revenant with sysid 104;

and now you can do the revokes using that username.

regards, tom lane