Re: postgres jdbc into eclipse plugin (OID problems) - Mailing list pgsql-jdbc

"Diego Zanga" <naarani@gmail.com> writes:
> the query i was using was something like:
> select tableA.fieldA, tableA.fieldB from tableA where tableA.fieldA=8
> the query report an error about >tableA<, but not WHERE/WITCH
> tableA word reported the error.

Maybe you need to be using a more recent version of Postgres?
I get messages like

regression=# create table foo(x int, y int);
CREATE TABLE
regression=# select foo.x, foo.y, foo.z from foo;
ERROR:  column foo.z does not exist
LINE 1: select foo.x, foo.y, foo.z from foo;
                             ^
regression=#

            regards, tom lane