Relation XX does not exist

Поиск
Список
Период
Сортировка
От Matt Allen
Тема Relation XX does not exist
Дата
Msg-id 20010405165316.C1919@lappy.insider.ctrllab.com
обсуждение исходный текст
Ответы Re: Relation XX does not exist  ("Poul L. Christiansen" <poulc@cs.auc.dk>)
Список pgsql-general
Hi Guys,

Just started using PG today, bought the book and all was cruising along well untill i got the following error:

Relation 'jobdetails' does not exist

when i issued:

INSERT INTO jobdetails (jobDetailsID, jobID, claimName , claimNumber ,placementDate , completionDate, invType ,
insType)values  
(7, 72,'P1234','Mr T',986453483,988639200, 'S', 'W')

All seems to be right here:

impmp=> \d
         List of relations
      Name      |   Type   | Owner
----------------+----------+-------
 jobDetails     | table    | impmp
 jobdetails_seq | sequence | impmp
 jobs           | table    | impmp
 jobs_seq       | sequence | impmp
(4 rows)

Any clues ? Ive restarted the SQL server and to no avail.

Thanks.
Matt

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

Предыдущее
От: Soma Interesting
Дата:
Сообщение: removing functions
Следующее
От: "Poul L. Christiansen"
Дата:
Сообщение: Re: Relation XX does not exist