| From: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | "parallel= " information is not coming in pg_dumpall for create aggregate |
| Date: | 2016-04-18 08:30:27 |
| Message-ID: | 57149B23.9030500@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I checked in PG 9.6 , if we create an aggregate function with saying -
parallel=safe/restricted/unsafe and then take
a pg_dumpall of the entire cluster , "parallel= " is missing from create
aggregate syntax
Steps to reproduce -
.)connect to psql terminal and create an aggregate function
postgres=# CREATE AGGREGATE unsafe_sum100 (float8)
(
stype = float8,
sfunc = float8pl,
mstype = float8,
msfunc = float8pl,
minvfunc = float8mi,
*parallel=safe*);
CREATE AGGREGATE
.)perform pg_dumpall against that cluster
.)check the content of create aggregate unsafe_sum100 in the file
"
-
-- Name: unsafe_sum100(double precision); Type: AGGREGATE; Schema:
public; Owner: centos
--
CREATE AGGREGATE unsafe_sum100(double precision) (
SFUNC = float8pl,
STYPE = double precision,
MSFUNC = float8pl,
MINVFUNC = float8mi,
MSTYPE = double precision
);
"
--
regards,tushar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2016-04-18 08:31:49 | Description of ForeignPath |
| Previous Message | Amit Langote | 2016-04-18 07:53:44 | Re: Declarative partitioning |