Re: simple insert operation - Mailing list pgsql-jdbc

Hi Ayd*n,

Others have addressed your compile errors, but I see something which might cause you problems at run time.

Identifiers which are not "quoted" will be treated as lower case in PostgreSQL, so your query will try to access
"passtable"."idcol"instead of "passTable"."idCol".  If you created the table without using quotes it will be in lower
caseand you will be OK referencing it without quotes no matter what capitalization you use; however, if the table
reallyexists in your database with the camel case identifiers, you must use quotes. 

-Kevin


>>> Ayd*n Toprak <aydin.toprak@intengo.com> 09/08/05 2:58 AM >>>

        String sqlQuery = "INSERT INTO passTable (idCol , pass) VALUES
(3, 5)";