Re: did not find any relation for existing table

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 <reapersoul(at)hotmail(dot)com> wrote:
>
>
> >
> >"Sinead O Brien" <reapersoul(at)hotmail(dot)com> 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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>