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

Re: "no relation entry for relid 1"

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: "no relation entry for relid 1"
Date: 2011-09-29 22:50:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On 29 September 2011 23:15, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Peter Geoghegan <peter(at)2ndquadrant(dot)com> writes:
>> 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?
> Looks like I broke it here:

Hmm. Although it was obvious to me that this was an internal error, I
have to wonder what a novice would have made of it. Specifically, I
wonder if there should be an INTERNAL_ERROR severity level, to
explicitly advertise that you're not supposed to see this, and to help
log analysis tools (including grep) bring these sorts of things to the
DBA's attention, as they are surely much more severe than most errors
seen in practice.

Peter Geoghegan
PostgreSQL Development, 24x7 Support, Training and Services

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-29 23:21:04
Subject: Re: "no relation entry for relid 1"
Previous:From: Tom LaneDate: 2011-09-29 22:15:50
Subject: Re: "no relation entry for relid 1"

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