Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist - Mailing list pgsql-admin

"Glen W. Mabey" <Glen.Mabey@swri.org> writes:
> When I SELECT any records from a certain table ("Acquisitions"), I get:

>     acqlibdb=> select * from "Acquisitions";
>     ERROR:  relation "Acquisitions" does not exist
>     acqlibdb=> select * from public."Acquisitions";
>     ERROR:  relation "public.Acquisitions" does not exist

Maybe it's not in the public schema but some other one (implying you
forgot about a nondefault search_path setting).

            regards, tom lane