Re: BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.
Date
Msg-id 6668.1390261693@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.  (Boszormenyi Zoltan <zboszor@pr.hu>)
List pgsql-bugs
Boszormenyi Zoltan <zboszor@pr.hu> writes:
> 2014-01-20 16:36 keltezéssel, Tom Lane írta:
>> Unfortunately, that's legal SQL syntax: stoerzeit_a11 is taken as a column
>> alias for sugru_9, even without AS in front of it.

> Still, this particular problem may be caught by the preprocessor.
> The SELECT targetlist is not "*", so the number of members for both
> the targetlist and the user structure (INTO :s_schichtsatz) are known.

Yeah, good point.  There was a comparable complaint a couple days ago
about plpgsql not checking its INTO target count carefully enough.
In both cases we could improve the odds of catching an error, even if
it wouldn't be perfect.

            regards, tom lane

pgsql-bugs by date:

Previous
From: mlipchuk@redhat.com
Date:
Subject: BUG #8880: no indication of value when exceeded maximum length
Next
From: Sandeep Thakkar
Date:
Subject: Re: permission issues with PostgreSQL 9.2 EnterpriseDB one-click installer on windows 7 causes initcluster to fail