Bug#612038: ERROR: cannot extract system attribute from minimal tuple

[Denis Feklushkin]

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
\.

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





-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org