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
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 |