[BUGS] no relation entry for relid 1

2011-09-29 Thread Peter Geoghegan
I've built Postgres from master, and found that the following fairly simple query breaks: select count(*) from ( select schemaname frompg_stat_user_tables order by1 ) sub group by schemaname This produces the internal error message no

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Merlin Moncure
On Thu, Sep 29, 2011 at 3:26 PM, Peter Geoghegan pe...@2ndquadrant.com wrote: 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        

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Peter Geoghegan
On 29 September 2011 21:59, Merlin Moncure mmonc...@gmail.com wrote: hm -- works for me (9.1.0) It works for me on REL9_1_STABLE too, unsurprisingly, as I would think it highly unlikely that such a glaring bug would slip into a stable release. -- Peter Geoghegan      

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Dickson S. Guedes
2011/9/29 Peter Geoghegan pe...@2ndquadrant.com: On 29 September 2011 21:59, Merlin Moncure mmonc...@gmail.com wrote: hm -- works for me (9.1.0) It works for me on REL9_1_STABLE too, unsurprisingly, as I would think it highly unlikely that such a glaring bug would slip into a stable release.

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Mark Kirkwood
On 30/09/11 10:08, Dickson S. Guedes wrote: 2011/9/29 Peter Geogheganpe...@2ndquadrant.com: On 29 September 2011 21:59, Merlin Moncuremmonc...@gmail.com wrote: hm -- works for me (9.1.0) It works for me on REL9_1_STABLE too, unsurprisingly, as I would think it highly unlikely that such a

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Tom Lane
Peter Geoghegan pe...@2ndquadrant.com writes: I've built Postgres from master, and found that the following fairly simple query breaks: select count(*) from ( select schemaname frompg_stat_user_tables order by1 ) sub group by

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Peter Geoghegan
On 29 September 2011 23:15, Tom Lane t...@sss.pgh.pa.us wrote: Peter Geoghegan pe...@2ndquadrant.com writes: I've built Postgres from master, and found that the following fairly simple query breaks: select count(*) from (       select       schemaname       from            

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Tom Lane
Peter Geoghegan pe...@2ndquadrant.com writes: On 29 September 2011 23:15, Tom Lane t...@sss.pgh.pa.us wrote: Looks like I broke it here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1cb108efb0e60d87e4adec38e7636b6e8efbeb57 Hmm. Although it was obvious to me that this was