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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG)
Дата
Msg-id 24332.1297312628@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Storing Media Types
Следующее
От: AI Rumman
Дата:
Сообщение: Full text t_tsquery is giving error