From: | "Herv Hnoch" <h(dot)henoch(at)isc84(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2224: unlogical syntax error |
Date: | 2006-01-30 10:47:10 |
Message-ID: | 20060130104710.8F788F0B00@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2224
Logged by: Herv Hnoch
Email address: h(dot)henoch(at)isc84(dot)org
PostgreSQL version: 8.1.2
Operating system: Linux FC4
Description: unlogical syntax error
Details:
I do this request :
select id_caisse as caisse from adm_pat where nip = '20020523' ;
Under PgAdmin this request work fine but via JDBC I have the following
messages server side :
CETLOG: statement: PREPARE <unnamed> AS SELECT id_caisse AS caisse FROM
adm_pat WHERE nip = '20020523'
CETLOG: statement: EXECUTE <unnamed> [PREPARE: SELECT id_caisse AS caisse
FROM adm_pat WHERE nip = '20020523']
CETLOG: statement: PREPARE <unnamed> AS SELECT adm_pat."nip", id_caisse
caisse FROM adm_pat WHERE nip = '20020523'
CETERROR: syntax error at or near "caisse" at character 33
CETLOG: statement: PREPARE <unnamed> AS SELECT id_caisse AS caisse FROM
adm_pat WHERE nip = '20020523'
CETLOG: statement: EXECUTE <unnamed> [PREPARE: SELECT id_caisse AS caisse
FROM adm_pat WHERE nip = '20020523']
The table adm_pat does not have another column named caisse. So what is the
problem (if problem).
Thanks a lot.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-01-30 13:21:34 | Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ... |
Previous Message | dueyduey | 2006-01-30 10:33:35 | BUG #2223: Misleading info in docs on volatility level of functions |