| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rene Pijlman | 2001-09-14 09:53:05 | Re: Transaction size limit & Data Truncation |
| Previous Message | Rene Pijlman | 2001-09-14 09:42:05 | Re: Using boolean '1' in jdbc2 |