problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist

From: "Glen W(dot) Mabey" <Glen(dot)Mabey(at)swri(dot)org>
To: PostgreSQL Admin Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
Date: 2007-03-09 15:40:13
Message-ID: 20070309154013.GA1790@bams.ccf.swri.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Huxton 2007-03-09 15:59:48 Re: index not being used. Why?
Previous Message Ireneusz Pluta 2007-03-09 15:18:49 Re: Pg_dump and bytaA