Re: Problems with column names in dot-notation

Can you get access to the server logs? I do these types of queries all
the time?

Dave
On Wed, 2002-08-14 at 08:47, Carsten Heidmann wrote:
> -----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
> -----------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>