Re: BUG #7703: Error with partitioning with distinct over aggregate - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7703: Error with partitioning with distinct over aggregate
Date
Msg-id 18647.1353952905@sss.pgh.pa.us
Whole thread Raw
In response to BUG #7703: Error with partitioning with distinct over aggregate  (maxim.boguk@gmail.com)
Responses Re: BUG #7703: Error with partitioning with distinct over aggregate
List pgsql-bugs
maxim.boguk@gmail.com writes:
> test=# create table test (id serial);
> NOTICE:  CREATE TABLE will create implicit sequence "test_id_seq" for serial
> column "test.id"
> CREATE TABLE
> test=# create index test_id_key on test(id);
> CREATE INDEX
> test=# create table test_part_1 (like test including all) INHERITS (test);
> NOTICE:  merging column "id" with inherited definition
> CREATE TABLE
> test=# explain analyze select distinct min(id) from test;
> ERROR:  failed to re-find MinMaxAggInfo record

Fixed, thanks for the report.

            regards, tom lane

pgsql-bugs by date:

Previous
From: wilson@leyou.com
Date:
Subject: BUG #7706: Can slave database supports creating temporary tables?
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #7706: Can slave database supports creating temporary tables?