Re: "no relation entry for relid 1" - Mailing list pgsql-bugs

From Merlin Moncure
Subject Re: "no relation entry for relid 1"
Date
Msg-id CAHyXU0wX7yjJokb-BGrz-gp38-vp3qeYyuDcZn8orM+zo5Gf+Q@mail.gmail.com
Whole thread Raw
In response to "no relation entry for relid 1"  (Peter Geoghegan <peter@2ndquadrant.com>)
Responses Re: "no relation entry for relid 1"
List pgsql-bugs
On Thu, Sep 29, 2011 at 3:26 PM, Peter Geoghegan <peter@2ndquadrant.com> wr=
ote:
> I've built Postgres from master, and found that the following fairly
> simple query breaks:
>
> select count(*)
> from
> (
> =A0 =A0 =A0 =A0select
> =A0 =A0 =A0 =A0schemaname
> =A0 =A0 =A0 =A0from =A0 =A0 =A0 =A0 =A0 =A0pg_stat_user_tables
> =A0 =A0 =A0 =A0order by =A0 =A0 =A0 =A01
> ) sub
> group by schemaname
>
> This produces the internal error message "no relation entry for relid
> 1". Why is that?

hm -- works for me (9.1.0)

merlin

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: "no relation entry for relid 1"
Next
From: Peter Geoghegan
Date:
Subject: Re: "no relation entry for relid 1"