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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #7703: Error with partitioning with distinct over aggregate
Дата
Msg-id 18647.1353952905@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #7703: Error with partitioning with distinct over aggregate  (maxim.boguk@gmail.com)
Ответы Re: BUG #7703: Error with partitioning with distinct over aggregate  (Maxim Boguk <maxim.boguk@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: wilson@leyou.com
Дата:
Сообщение: BUG #7706: Can slave database supports creating temporary tables?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #7706: Can slave database supports creating temporary tables?