Re: Upgraded, now permission denied.

Jason Whitener <jwhitene(at)pcc(dot)edu> writes:
> Queries that used to run on 8.1 now complain about relations not found,
> like:
> Select * from uiddate where dateonline >= '#hourago#'
> returns: ERROR: relation "uiddate" does not exist Position: 15

> The database name is 'mypcc'. The schema is 'public'. I can visibly see
> the table 'uiddate' in the PgAdmin gui.

> If I do a query like:
> SELECT * FROM public.uiddate where dateonline >= '2014-06-11 14:33:14';
> It returns:
> ERROR: permission denied for schema public

I suspect these are both symptoms of the same problem, namely that
the "public" schema lacks public access permissions. I'm not sure
exactly how it got that way --- might be interesting to look at

select * from pg_namespace where nspname = 'public';

and if you still have the pg_dump file from 8.1, look to see if
there are any grant/revoke commands for schema public in it.

But in any case, the fix is probably

grant all on schema public to public;

regards, tom lane