Re: "no relation entry for relid 1" - Mailing 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