Re: UPDATE crash in HEAD and 8.1

Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Tom Lane wrote:
> >> I'm fairly sure this query is illegal per spec.  There are ancient
> >> discussions in the archives about whether aggregates in an UPDATE target
> >> list can have a consistent interpretation or not.  We never found one,
> >> but never got around to disallowing it either.  Maybe it's time.  If you
> >> try it with something like sum() you don't get a crash, but you do get
> >> rather bizarre behavior.
> 
> > Yeah, I agree we should disallow it.  For the curious, the bizarre behavior
> > is
> 
> > alvherre=# update pk set id = count(id) ;
> > ERROR:  ctid is NULL
> 
> Hmm, what version are you testing?  What I see is that it updates a
> single one of the table rows :-(

The trick seems to be that the table must be empty.  I'm doing this in
8.1.3.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.