Re: [NOVICE] Error Relation xxxx does not exist when trying to insert new row

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [NOVICE] Error Relation xxxx does not exist when trying to insert new row
Дата
Msg-id 6CF8D4A8-00F3-47D3-9BC5-DA7F6AD8489D@a-kretschmer.de
обсуждение исходный текст
Ответ на [NOVICE] Error Relation xxxx does not exist when trying to insert new row  (William Colls <william@williamcollsassoc.ca>)
Ответы Re: [NOVICE] Error Relation xxxx does not exist when trying to insertnew row
Список pgsql-novice

Am 31. Mai 2017 04:54:20 MESZ schrieb William Colls <william@williamcollsassoc.ca>:
>Environment: Kubuntu 16.04 64 bit: Postgresql 9.5.6 installed from
>repository.
>
>When I try to insert a new row into a table, I am getting the error
>relation "xxxx" does not exist.
>
>However:
>
>  * in psql the command \d shows "xxxx" to be in the public schema of
>    the current database, and owned by the current user.
>  * SHOW search_path returns "$user", public
>  * The table, and its columns, were created using pgadmin3. A small
>test table created from within psql works just fine; no error on
>insert.
>  * The properties of the two tables appear to be the same, when viewed
>    in pgadmin3
>
>What am I missing?
>
>I know this is pretty basic, and I should be able to figure it out for
>myself, but for now it has me beat.
>
>Thanks for your time.
>
>William.

Maybe a problem with lower/uppercase. Please show us \d in psql and the exact errormessage.

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.


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

Предыдущее
От: William Colls
Дата:
Сообщение: [NOVICE] Error Relation xxxx does not exist when trying to insert new row
Следующее
От: William Colls
Дата:
Сообщение: Re: [NOVICE] Error Relation xxxx does not exist when trying to insertnew row