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

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.