Skip site navigation (1) Skip section navigation (2)

Re: ERROR: ExecutePlan: (junk) `ctid' is NULL!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)nasby(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: ExecutePlan: (junk) `ctid' is NULL!
Date: 2003-04-29 22:36:59
Message-ID: 17441.1051655819@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> stats=> UPDATE Tsummary
> stats->     SET participants = count(distinct credit_id)
> stats->             , teams = count(distinct team_id)
> stats->     FROM email_contrib_today ect
> stats->     WHERE ect.project_id = :ProjectID
> stats-> ;
> ERROR:  ExecutePlan: (junk) `ctid' is NULL!

We really oughta reject UPDATE commands with aggregates at the top
level.  It's not well-defined, it's illegal per SQL spec, and it tends
to get the executor all confused ...

			regards, tom lane


In response to

Responses

pgsql-general by date

Next:From: Hadley WillanDate: 2003-04-29 22:43:26
Subject: Simple question about messages
Previous:From: Tom LaneDate: 2003-04-29 22:34:57
Subject: Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group