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
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 th
8.0.3 is more than two years old --- you really ought to update to the
latest in that branch (8.0.13 currently), if not upgrade to 8.1.x or
8.2.x branches. I do see a post-8.0.3 fix that might explain loss of
index entries, so trying a reindex is worth doing at this point.
Thank you very muc
"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
>>
"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
"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 th
Removing the semicolon gives the same output.
cdx_post=# \d history.client
Did not find any relation named "history.client".
Without actually trying it out myself, I wonder if the final semi-colon on
your command is causing problems - as far as I recall (I don't use psql a
whole lot), you n
On 06/05/2007 23:05, Sinead O Brien wrote:
cdx_post=# \d history.client;
Did not find any relation named "history.client".
Without actually trying it out myself, I wonder if the final semi-colon
on your command is causing problems - as far as I recall (I don't use
psql a whole lot), you need
Hello
I am receiving a "did not find any relation" error in pgsql for a table
which I know exists. The outputs from the commands are as follows
cdx_post=# \d history.client;
Did not find any relation named "history.client".
cdx_post=# \dt history.clien*
List of relations
Schema
