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.