"parallel= " information is not coming in pg_dumpall for create aggregate
От | tushar |
---|---|
Тема | "parallel= " information is not coming in pg_dumpall for create aggregate |
Дата | |
Msg-id | 57149B23.9030500@enterprisedb.com обсуждение исходный текст |
Ответы |
Re: "parallel= " information is not coming in pg_dumpall
for create aggregate
|
Список | pgsql-hackers |
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>
В списке pgsql-hackers по дате отправления: