relation does not exist error

Поиск
Список
Период
Сортировка
От Simon Wittber
Тема relation does not exist error
Дата
Msg-id 4e4a11f80412021901295079b3@mail.gmail.com
обсуждение исходный текст
Ответы Re: relation does not exist error
Re: relation does not exist error
Список pgsql-general
I'm evaluationg PostgreSQL 8.0 beta 5 for a new development project.

I've created a user 'simon' and a database named 'WMSDV'.

I've created some tables (see below) and assigned arwdRxt privledges
to the 'simon' user.

However, when i use psql, I am unable to select these tables. I
receive a 'relation "'tabename' does not exist" error. I'm completely
new to PostgreSQL, and this problem has me stumped.

Can anyone point me in the right direction?

Sw.

WMSDV=# \dt
         List of relations
 Schema |   Name    | Type  | Owner
--------+-----------+-------+-------
 public | Customers | table | simon
 public | Persons   | table | simon
(2 rows)

WMSDV=# select * from Customers;
ERROR:  relation "customers" does not exist
WMSDV=# select * from public.Customers;
ERROR:  relation "public.customers" does not exist
WMSDV=#

В списке pgsql-general по дате отправления:

Предыдущее
От: "Berend Tober"
Дата:
Сообщение: Re: Rules
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: relation does not exist error