Re: Fwd: cant insert into a post gre sql table...Can u please help in fixing this - Mailing list pgsql-bugs

From David G Johnston
Subject Re: Fwd: cant insert into a post gre sql table...Can u please help in fixing this
Date
Msg-id 1397504039242-5799972.post@n5.nabble.com
Whole thread Raw
In response to Fwd: cant insert into a post gre sql table...Can u please help in fixing this  (kona ajay <konaajay@gmail.com>)
List pgsql-bugs
kona ajay wrote
> "insert into  VSP_Employee values [...]

If you managed to create the table in a case-sensitive manner you will need
to refer to it in the same way - namely with double-quotes surrounding the
identifier.  Otherwise all identifiers are case-folded to lower case.

"VSP_Employee" -> same
VSP_Employee -> vsp_employee

My other guess is you think you are hitting a database with the table but in
reality you are connecting to a different database where the table does not
exist.

David J.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/cant-insert-into-a-post-gre-sql-table-Can-u-please-help-in-fixing-this-tp5799954p5799972.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10006: 'DO INSTEAD UPDATE' error
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #10014: Does not work PQfn in libpq with array