I think most of this comes from matching names as strings (with RangeVars from qualified_name_list). BCN-036R1 says the entries in the exclude list should be resolved the same way as column references in the select list. So perhaps each entry could be transformed as an ordinary ColumnRef, and the star expansion could then skip the columns whose Var matches, without modifying the namespace item. That would give error positions and correct handling of aliases and schemas for free.
Thanks for reviewing the patch and reporting bugs. I already switched to
ColumnRef in the upcoming patch since I also found similar kinds of issues.
These issues would hopefully be fixed in the new version.
Hunaid, are you planning to post a v3 with the standard syntax? I'd be glad to test it.
Sorry for the delay, I was busy with some other important stuff during
this period. v3 is around the corner that includes support for new
standard syntax with REPLACE and RENAME clauses.
If everything looks good, you might see a new version of patch this week.
