"no relation entry for relid 1"

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: "no relation entry for relid 1"
Date: 2011-09-29 20:26:36
Message-ID: CAEYLb_Wn2_6g7hJU=PHmo10qqFbrh5xyks2UmuhESeC143-+Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I've built Postgres from master, and found that the following fairly
simple query breaks:

select count(*)
from
(
select
schemaname
from pg_stat_user_tables
order by 1
) sub
group by schemaname

This produces the internal error message "no relation entry for relid
1". Why is that?

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Merlin Moncure 2011-09-29 20:59:02 Re: "no relation entry for relid 1"
Previous Message Robert Haas 2011-09-29 15:39:28 Re: BUG #6231: weird to_timestamp behaviour with out of range values