Problems with column names in dot-notation

Поиск
Список
Период
Сортировка
От Carsten Heidmann
Тема Problems with column names in dot-notation
Дата
Msg-id 5.1.0.14.0.20020814143749.03af3a08@uranos
обсуждение исходный текст
Ответы Re: Problems with column names in dot-notation
Список pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,
I'm using PostgreSQL 7.2.1 on Solaris 8 (SunOS 5.8). I'm trying to get a
String from my db, using a very simple select command. Executing the
command in psql or even via phpPgAdmin works fine, but when I try to
retrieve the same information via JDBC I get the following error:
"SQL-Error: The column name sometable.somefield not found."
Executing the same command with a field name without the table name
("somefield") works, when the field name is not ambiguous.

If anyone has a solution for this, I would really appreciate it.

My locale and the db-encoding is set to en_US.ISO8859-15 and the JVM is
started with "-Dfile.encoding=ISO8859-15".

Regards, Carsten

-----BEGIN PGP SIGNATURE-----
Version: 6.5.8ckt

iQA/AwUBPVpDN7jxzYr/SJ6uEQIyegCePfDJeUjBFAltI0rLqthugjijo1oAoKn0
HdcIvr5ouzq9/Ym5Uyn2BtT9
=wCmq
-----END PGP SIGNATURE-----
-----------------------------------------------------------
Dipl. Geogr. Carsten Heidmann
Tel.: 040.81908.345
Fax: 040.81908.373
heidmann@hamburg.baw.de
http://nokis.baw.de/

Bundesanstalt fuer Wasserbau
- Aussenstelle Kueste -
Wedeler Landstrasse 157
DE - 22559 Hamburg
-----------------------------------------------------------


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: shanmugavel
Дата:
Сообщение: Abrupt connection closure while handling large objects
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Problems with column names in dot-notation