Re: Fwd: cant insert into a post gre sql table...Can u please help in fixing this

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Fwd: cant insert into a post gre sql table...Can u please help in fixing this
Date: 2014-04-14 19:33:59
Message-ID: 1397504039242-5799972.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2014-04-14 19:35:04 Re: BUG #10014: Does not work PQfn in libpq with array
Previous Message Tom Lane 2014-04-14 19:11:39 Re: BUG #10006: 'DO INSTEAD UPDATE' error