From: Glen W. Mabey <Glen.Mabey@swri.org>
To: PostgreSQL Admin Mailing List <pgsql-admin@postgresql.org>
Subject: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
Date: Fri, 9 Mar 2007 09:40:13 -0600
Message-ID: <20070309154013.GA1790@bams.ccf.swri.edu> (raw)
Hello,
After upgrading from 8.1.6 to 8.1.8 (using Debian testing packages) I
started to get a really strange error, and I have not been able to gain
any insights into this from the list archives.
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
However, a View that is based on that table still works:
acqlibdb=> select * from "ViewAcquisitions" LIMIT 2;
and
acqlibdb=> select * from pg_tables;
shows "Acquisitions" as the final result.
Any ideas????? I'm desparate here.
Thanks,
Glen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Glen.Mabey@swri.org
Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
In-Reply-To: <20070309154013.GA1790@bams.ccf.swri.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox