From: | "Sinead O Brien" <reapersoul(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | did not find any relation for existing table |
Date: | 2007-05-06 22:05:02 |
Message-ID: | BAY18-F395C3D35DFE0207F0EE71DB460@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Name | Type | Owner
---------+-----------------+-------+-------
history | client | table | pgsql
history | client_activity | table | pgsql
history | client_flag | table | pgsql
cdx_post=# \d history.clien*
Table "history.client"
Column | Type |
Modifiers--------------------------------+--------------------------------+--------------------------
order_id | integer | not null
history_id | integer | not null
active | boolean |
client_id | character varying(32) | not null
So, the table is there, but I can't access it using its name. Any
suggestions would be greatly appreciated.
Thank you and Regards,
Sinead O Brien
_________________________________________________________________
Message offline contacts without any fire risk!
http://www.communicationevolved.com/en-ie/
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-05-06 22:11:51 | Re: did not find any relation for existing table |
Previous Message | Martin Gainty | 2007-05-06 21:41:45 | Re: shmget fails on OS X with proper settings |