Re: BUG #7703: Error with partitioning with distinct over aggregate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maxim(dot)boguk(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7703: Error with partitioning with distinct over aggregate
Date: 2012-11-26 18:01:45
Message-ID: 18647.1353952905@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

maxim(dot)boguk(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Kroon 2012-11-26 20:38:03 Re: npgssql 5gb installation
Previous Message wilson 2012-11-26 13:59:44 BUG #7706: Can slave database supports creating temporary tables?