On Jan 10, 2006, at 8:32 , Tom Lane wrote:

Attached is a proposed change to create hopefully-more-useful error
messages in the cases where we currently say "missing FROM-clause entry".

It's good to have these hints for users. Thanks, Tom.

regression=# select * from a,b join c on (a.aa = c.cc);
ERROR:  invalid reference to FROM-clause entry for table "a"
HINT: There is an entry for "a", but it cannot be referenced from this part of the query.

For clarity, I'd rewrite this hint as
There is an entry for table "a", ...

Michael Glaesemann
grzm myrealbox com

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to