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)
"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