"Diego Zanga" <naarani(at)gmail(dot)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