>>
>> I'd want it to error out on "INSERT foo (bar.col)", though ;-)
>>
>
> And on "INSERT foo (bar.foo.col)" as well.
Why accept above at all ? Seems much too error prone, I would eighter
accept table with schema or without schema, mixing both cases seems
unnecessarily confusing and error prone to me.
If at all, I would allow:
INSERT bar.foo (bar.foo.col)
INSERT foo (foo.col)
Would that be enough for the initial problem case ?
Andreas