Hi,<br /><br /> I checked in PG 9.6 , if we create an aggregate function with saying - parallel=safe/restricted/unsafe
andthen take<br /> a pg_dumpall of the entire cluster , "parallel= " is missing from create aggregate syntax <br /><br
/>Steps to reproduce -<br /><br /> .)connect to psql terminal and create an aggregate function <br /><br /> postgres=#
CREATEAGGREGATE unsafe_sum100 (float8)<br /> (<br /> stype = float8,<br /> sfunc = float8pl,<br /> mstype =
float8,<br/> msfunc = float8pl,<br /> minvfunc = float8mi,<br /> <b> parallel=safe</b>);<br /> CREATE
AGGREGATE<br/><br /> .)perform pg_dumpall against that cluster <br /><br /> .)check the content of create aggregate
unsafe_sum100in the file <br /><br /> "<br /> -<br /> -- Name: unsafe_sum100(double precision); Type: AGGREGATE;
Schema:public; Owner: centos<br /> --<br /><br /> CREATE AGGREGATE unsafe_sum100(double precision) (<br /> SFUNC =
float8pl,<br/> STYPE = double precision,<br /> MSFUNC = float8pl,<br /> MINVFUNC = float8mi,<br />
MSTYPE= double precision<br /> );<br /><br /> "<br /><pre class="moz-signature" cols="72">--
regards,tushar
</pre>