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