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

From Tom Lane
Subject Re: "no relation entry for relid 1"
Date
Msg-id 22184.1317334550@sss.pgh.pa.us
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"  (Peter Geoghegan <peter@2ndquadrant.com>)
List pgsql-bugs
Peter Geoghegan <peter@2ndquadrant.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:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1cb108efb0e60d87e4adec38e7636b6e8efbeb57

Fixed, thanks for the report!

            regards, tom lane

pgsql-bugs by date:

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