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

["Greg Sabino Mullane" <greg(at)turnstep(dot)com>]

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;

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200703091547
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFF8cfuvJuQZxSWSsgRA0HYAJ0dWE1L3Ewzu8D8pWyJZd8vniw2zgCfaqYZ
zCX9tS5iBecoDP7nn5A7Jy0=
=0XFc
-----END PGP SIGNATURE-----