Skip site navigation (1) Skip section navigation (2)

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

From: Denis Feklushkin <denis(dot)feklushkin(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: [Fwd: ERROR: cannot extract system attribute from minimal tuple]
Date: 2011-02-09 19:53:28
Message-ID: 1297281208.4165.0.camel@localhost (view raw or flat)
Thread:
Lists: pgsql-bugs
-------- Пересылаемое сообщение --------
От: 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
\.

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




Responses

pgsql-bugs by date

Next:From: Andi SielickiDate: 2011-02-09 20:14:50
Subject: BUG #5875: can not make a backup
Previous:From: Jan-Peter SeifertDate: 2011-02-09 09:57:11
Subject: BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group