Quick Links

Re: "no relation entry for relid 1"

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Cc:	pgsql-bugs(at)postgresql(dot)org
Subject:	Re: "no relation entry for relid 1"
Date:	2011-09-29 22:15:50
Message-ID:	22184.1317334550@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

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:

Fixed, thanks for the report!

regards, tom lane

	From	Date	Subject
Next Message	Peter Geoghegan	2011-09-29 22:50:13	Re: "no relation entry for relid 1"
Previous Message	Mark Kirkwood	2011-09-29 21:59:43	Re: "no relation entry for relid 1"