[Fwd: ERROR: cannot extract system attribute from minimal tuple]

-------- Пересылаемое сообщение --------
От: Denis Feklushkin <denis(dot)feklushkin(at)gmail(dot)com>
Кому: submit(at)bugs(dot)debian(dot)org
Тема: ERROR: cannot extract system attribute from minimal tuple
Дата: Sat, 05 Feb 2011 09:50:06 +0700

Package: postgresql-9.0
Version: 9.0.3-1
Severity: normal
Tags: upstream

Query:

SELECT currency_id1
FROM bug0.currency_pairs p
FOR SHARE;

returns error:
ERROR: cannot extract system attribute from minimal tuple

Schema:

---------------------------
CREATE SCHEMA bug0;

SET search_path = bug0, pg_catalog;

CREATE VIEW insider AS
SELECT true AS insider;

CREATE TABLE pairs (
currency_id1 text,
currency_id2 text,
hidden boolean,
pair_id integer
);

CREATE VIEW currency_pairs AS
SELECT p.pair_id, p.currency_id1, p.currency_id2
FROM (pairs p CROSS JOIN insider i) WHERE ((NOT p.hidden) OR
i.insider)
ORDER BY p.pair_id;

COPY pairs (currency_id1, currency_id2, hidden, pair_id) FROM stdin;
BTC RUB f 1
\.

---------------------------