Skip site navigation (1) Skip section navigation (2)

Re: Fw: JDBC Bug Report

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: leochan(at)email(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org, Peter T Mount <peter(at)retep(dot)org(dot)uk>
Subject: Re: Fw: JDBC Bug Report
Date: 2001-09-14 09:47:47
Message-ID: q9k3qtc3sit5avg5je169d448jgh5tvisu@4ax.com (view raw or flat)
Thread:
Lists: 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(at)lab(dot)applinet(dot)nl>

In response to

pgsql-jdbc by date

Next:From: Rene PijlmanDate: 2001-09-14 09:53:05
Subject: Re: Transaction size limit & Data Truncation
Previous:From: Rene PijlmanDate: 2001-09-14 09:42:05
Subject: Re: Using boolean '1' in jdbc2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group