The following bug has been logged online:
Bug reference: 2224
Logged by: Hervé Hénoch
Email address: h.henoch@isc84.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.
