From: Glen W. Mabey <Glen.Mabey@swri.org>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
Date: Fri, 9 Mar 2007 14:56:03 -0600
Message-ID: <20070309205603.GF2153@bams.ccf.swri.edu> (raw)
In-Reply-To: <5140152e00e28ac90209884943d60d3d@biglumber.com>
References: <20070309191112.GB2153@bams.ccf.swri.edu>
<5140152e00e28ac90209884943d60d3d@biglumber.com>
On Fri, Mar 09, 2007 at 08:51:44PM +0000, Greg Sabino Mullane wrote:
>
> Hash: RIPEMD160
>
>
> > > > When I SELECT any records from a certain table ("Acquisitions"), I get:
> > >
> > > > acqlibdb=> select * from "Acquisitions";
> > > > ERROR: relation "Acquisitions" does not exist
> ..>
> > Humm. I don't think so, since I've never altered the search_path
> > settings, nor used any schema besides public. And I've been working
> > with this database for 8 months now without ever encountering such an
> > error. And all of the other tables work just fine.
>
> See what this gives you:
>
> SELECT nspname, relname, relkind
> FROM pg_class c, pg_namespace n
> WHERE c.relnamespace = n.oid
> AND lower(relname) ~ 'acqu'
> ORDER BY 2,1,3;
I have no idea what that does, but here is the output:
nspname | relname | relkind
---------+------------------------------+---------
public | Acquisition_pkey | i
public | Acquisitions | r
public | Acquisitions_id_seq | S
public | Acquisitions_location_id_key | i
public | ViewAcquisitions | v
public | viewacquisitionsnew | v
What I see is a bunch of stuff related to the Acquisitions table,
including a relation for the primary key, which was created back when
the table was named "Acquisition" (not plural), and two different views
which draw on Acquisitions, both of which appear to be fully
functional.
Thanks for you reply --
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, greg@turnstep.com
Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
In-Reply-To: <20070309205603.GF2153@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