Re: [PATCHES] Proposed patch to change "missing FROM" messages

[Tom Lane]

Michael Glaesemann <[EMAIL PROTECTED]> writes:
> For clarity, I'd rewrite this hint as
> There is an entry for table "a", ...

Done.  Anyone have any other suggestions for wording improvements?

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [PATCHES] Proposed patch to change "missing FROM" messages

[Michael Glaesemann]

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.


Patch:
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?

  http://archives.postgresql.org