Re: Proposed patch to change "missing FROM" messages - Mailing list pgsql-patches

From Michael Glaesemann
Subject Re: Proposed patch to change "missing FROM" messages
Date
Msg-id 434FFEA2-1A13-45CF-BB09-577FEC63F30D@myrealbox.com
Whole thread Raw
In response to Proposed patch to change "missing FROM" messages  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Proposed patch to change "missing FROM" messages
List pgsql-patches
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




pgsql-patches by date:

Previous
From: Joachim Wieland
Date:
Subject: TODO-item: Add sleep() function, remove from regress.c
Next
From: Neil Conway
Date:
Subject: Re: pl/python refcount bug