From: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #7703: Error with partitioning with distinct over aggregate |
Date: | 2012-11-27 00:14:40 |
Message-ID: | CAK-MWwTFL==S7SdL4S0PtXqfkaihoZf8PPrGBwWcSczdJRd-MQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Nov 27, 2012 at 5:01 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
Thank you very much.
PS: I know that the query sounds stupid, but most CMS/ORM
unfortunately could produce unlimited amount of strange/stupid
queries.
--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | tgarnett | 2012-11-27 15:55:28 | BUG #7709: psql \copy csv terminates with \. in quoted region |
Previous Message | Bruce Momjian | 2012-11-26 20:48:36 | Re: BUG #7706: Can slave database supports creating temporary tables? |