Re: [NOVICE] Error Relation xxxx does not exist when trying to insert new row - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: [NOVICE] Error Relation xxxx does not exist when trying to insert new row
Date
Msg-id 6CF8D4A8-00F3-47D3-9BC5-DA7F6AD8489D@a-kretschmer.de
Whole thread Raw
In response to [NOVICE] Error Relation xxxx does not exist when trying to insert new row  (William Colls <william@williamcollsassoc.ca>)
Responses Re: [NOVICE] Error Relation xxxx does not exist when trying to insertnew row  (William Colls <william@williamcollsassoc.ca>)
List 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 by date:

Previous
From: William Colls
Date:
Subject: [NOVICE] Error Relation xxxx does not exist when trying to insert new row
Next
From: William Colls
Date:
Subject: Re: [NOVICE] Error Relation xxxx does not exist when trying to insertnew row