Re: aggregate + view + alias crash on 7.4 stable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: aggregate + view + alias crash on 7.4 stable
Date
Msg-id 1886.1070857557@sss.pgh.pa.us
Whole thread Raw
In response to aggregate + view + alias crash on 7.4 stable  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: aggregate + view + alias crash on 7.4 stable  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> test=# select count(a.*) from pg_indexes a limit 10;
> server closed the connection unexpectedly

Hmmm ... the crash is certainly UnGood, but is there any reason we
should accept this query rather than generating an error?  I don't
think it's legal vanilla SQL --- the argument of count() should be
either "*" or a scalar expression per the spec.  I don't know what
it means for the argument of count() to be "foo.*".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Call for pg_dump testing
Next
From: Tom Lane
Date:
Subject: Re: Call for pg_dump testing