Re: simple insert operation

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: simple insert operation
Дата
Msg-id s32070ea.096@gwmta.wicourts.gov
обсуждение исходный текст
Ответ на simple insert operation  (Aydın Toprak <aydin.toprak@intengo.com>)
Список 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)";


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: SELECT COUNT(*) does a scan?
Следующее
От: Aydın Toprak
Дата:
Сообщение: Re: simple insert operation