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

From Tom Lane
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
Msg-id 24332.1297312628@sss.pgh.pa.us
Whole thread Raw
In response to 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG)  ("David Johnston" <polobo@yahoo.com>)
Responses Re: 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG)  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
"David Johnston" <polobo@yahoo.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

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Storing Media Types
Next
From: AI Rumman
Date:
Subject: Full text t_tsquery is giving error