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@turnstep.com
PGP Key: 0x14964AC8 200703091547
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFF8cfuvJuQZxSWSsgRA0HYAJ0dWE1L3Ewzu8D8pWyJZd8vniw2zgCfaqYZ
zCX9tS5iBecoDP7nn5A7Jy0=
=0XFc
-----END PGP SIGNATURE-----