Hello, Please check the output of the below query.
select tablename,schemaname from pg_tables where schemaname='history'; I assume that the table might have created under public schema. Please check the output of the above query and if the output consists of public in place of schemaname column then the object is residing in public schema not in history schema. Please try this. Regards, Prashant Ranjalkar EnterpriseDB On 5/7/07, Sinead O Brien <[EMAIL PROTECTED]> wrote:
> >"Sinead O Brien" <[EMAIL PROTECTED]> writes: > > I am receiving a "did not find any relation" error in pgsql for a table > > which I know exists. > >Hm, what PG version is this? It might be that reindexing pg_class will >fix it, but it would be nice to try to determine what's wrong before >overwriting the evidence. > Thanks for the response, version is psql (PostgreSQL) 8.0.3 _________________________________________________________________ Message offline contacts without any fire risk! http://www.communicationevolved.com/en-ie/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
