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

BUG #2224: unlogical syntax error

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 (view raw or flat)
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.

Responses

pgsql-bugs by date

Next:From: Andrew DunstanDate: 2006-01-30 13:21:34
Subject: Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ...
Previous:From: dueydueyDate: 2006-01-30 10:33:35
Subject: BUG #2223: Misleading info in docs on volatility level of functions

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