Сreate parallel aggregate

From: Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Сreate parallel aggregate
Date: 2016-09-29 14:07:52
Message-ID: b1e247ca-23ad-1d24-cecc-28600550f7bb@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, everyone!

I was trying to create a parallel aggregate with base_type parameter and
failed

postgres=# CREATE AGGREGATE ST_Extent_parallel (
sfunc = ST_CombineBBox,
combinefunc = ST_CombineBBox,
finalfunc = box2d,
stype = box3d,
basetype = geometry,
parallel = safe
);
ERROR: syntax error at or near "parallel"
LINE 7: parallel = safe

But everything is ok if I use arg_data_type:

postgres=# CREATE AGGREGATE ST_Extent_parallel(geometry) (
sfunc = ST_CombineBBox,
combinefunc = ST_CombineBBox,
finalfunc = box2d,
stype = box3d,
parallel = safe
);
CREATE AGGREGATE

Is that a bug or a feature?

--
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-09-29 14:26:57 Re: Сreate parallel aggregate
Previous Message Nguyễn Trần Quốc Vinh 2016-09-29 14:07:24 Re: Incrementally refreshed materialized view