| 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: | Whole Thread | Raw Message | 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 |