Re: 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Johnston" <polobo(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG)
Date: 2011-02-10 04:37:08
Message-ID: 24332.1297312628@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David Johnston" <polobo(at)yahoo(dot)com> writes:
> More simply if you run any query of the form:
> SELECT subquerycolumn
> FROM (
> SELECT subquerycolumn FROM table WHERE [condition] FOR UPDATE -- WHERE
> is optional but obviously useful; FOR SHARE also causes this behavior
> ) intermediate
> The error "cannot extract system attribute from virtual tuple" is thrown IIF
> the sub-query returns one or more records.

Fixed, thanks for the report!

http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d5478c3391f8f1a243abbc3d9253aac3d6d3538e

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2011-02-10 05:16:18 Full text t_tsquery is giving error
Previous Message David Johnston 2011-02-10 03:16:33 Re: Storing Media Types