BUG #2224: unlogical syntax error
От | Hervé Hénoch |
---|---|
Тема | BUG #2224: unlogical syntax error |
Дата | |
Msg-id | 20060130104710.8F788F0B00@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2224: unlogical syntax error
Re: BUG #2224: unlogical syntax error |
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: