Re: [BUGS] BUG #7703: Error with partitioning with distinct over aggregate

2012-11-26 Thread Maxim Boguk
On Tue, Nov 27, 2012 at 5:01 AM, Tom Lane wrote: > maxim.bo...@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 IN

Re: [BUGS] BUG #7703: Error with partitioning with distinct over aggregate

2012-11-26 Thread Tom Lane
maxim.bo...@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

[BUGS] BUG #7703: Error with partitioning with distinct over aggregate

2012-11-25 Thread maxim . boguk
The following bug has been logged on the website: Bug reference: 7703 Logged by: Maksym Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.2.1 Operating system: Any Description: Simple test case: test=# create table test (id serial); NOTICE: CREATE TAB