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

From Peter Geoghegan
Subject "no relation entry for relid 1"
Date
Msg-id CAEYLb_Wn2_6g7hJU=PHmo10qqFbrh5xyks2UmuhESeC143-+Xg@mail.gmail.com
Whole thread Raw
Responses Re: "no relation entry for relid 1"  (Merlin Moncure <mmoncure@gmail.com>)
Re: "no relation entry for relid 1"  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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=09
) sub
group by schemaname

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

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

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6231: weird to_timestamp behaviour with out of range values
Next
From: Merlin Moncure
Date:
Subject: Re: "no relation entry for relid 1"