Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Glen W. Mabey" <Glen(dot)Mabey(at)swri(dot)org>
- Cc: PostgreSQL Admin Mailing List <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- Date: Fri, 09 Mar 2007 11:41:23 -0500
"Glen W. Mabey" <Glen(dot)Mabey(at)swri(dot)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
- Follow-Ups:
- References:
- problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- From: Glen W. Mabey
- problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- Prev by Date: Re: Pg_dump and bytaA
- Next by Date: Re: Pg_dump and bytaA
- Previous by thread: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- Next by thread: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- Indexes: