Problems with column names in dot-notation

-----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(at)hamburg(dot)baw(dot)de
http://nokis.baw.de/

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