Re: Fw: JDBC Bug Report - Mailing list pgsql-jdbc

From Rene Pijlman
Subject Re: Fw: JDBC Bug Report
Date
Msg-id q9k3qtc3sit5avg5je169d448jgh5tvisu@4ax.com
Whole thread Raw
In response to Fw: JDBC Bug Report  (Peter T Mount <peter@retep.org.uk>)
List pgsql-jdbc
On Fri, 14 Sep 2001 04:55:06 -0400 (EDT), you wrote:
>I have a table with those column name "position" and "local"
[parse error near local]
>I think this is a bug since as I just change the field name in
>the table and recompile my application and can run with no error.

"local" is a reserved word in SQL92/99 and in PostgreSQL. See
http://www.postgresql.org/idocs/index.php?sql-keywords-appendix.html.

This is not a bug, therefore. You should choose another column
name.

Regards,
René Pijlman <rene@lab.applinet.nl>

pgsql-jdbc by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: Using boolean '1' in jdbc2
Next
From: Rene Pijlman
Date:
Subject: Re: Transaction size limit & Data Truncation