From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org,William Colls <william(at)williamcollsassoc(dot)ca> |
Subject: | Re: Error Relation xxxx does not exist when trying to insert new row |
Date: | 2017-05-31 04:03:37 |
Message-ID: | 6CF8D4A8-00F3-47D3-9BC5-DA7F6AD8489D@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am 31. Mai 2017 04:54:20 MESZ schrieb William Colls <william(at)williamcollsassoc(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | William Colls | 2017-05-31 13:57:39 | Re: Error Relation xxxx does not exist when trying to insert new row |
Previous Message | William Colls | 2017-05-31 02:54:20 | Error Relation xxxx does not exist when trying to insert new row |