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

From Tatsuo Ishii
Subject Re: aggregate + view + alias crash on 7.4 stable
Date
Msg-id 20031208.143609.104031715.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: aggregate + view + alias crash on 7.4 stable  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: aggregate + view + alias crash on 7.4 stable  (Tom Lane <tgl@sss.pgh.pa.us>)
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.*".

If the SQL is not legal, generating an error is enough, I think.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Call for pg_dump testing
Next
From: strk
Date:
Subject: ERROR: Index pg_toast_8443892_index is not a btree