Tom Lane wrote:
>
> I'd want it to error out on "INSERT foo (bar.col)", though ;-)
>
And on "INSERT foo (bar.foo.col)" as well.
This means we will have to take this check down to the analyze
phase (where the schema where foo is located is finally known,
if it was not specified explicitly).
We could easily take "INSERT bar.foo (bar.foo.col)" but the
above one is trouble.
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
