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

[Denis Feklushkin]

-------- Пересылаемое сообщение --------
От: Denis Feklushkin <denis.feklush...@gmail.com>
Кому: sub...@bugs.debian.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
\.

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




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs