From ab4847d3dd345f9dedeed66a736dd614239e6d26 Mon Sep 17 00:00:00 2001 From: Craig Ringer Date: Fri, 25 Apr 2014 18:55:48 +0800 Subject: [PATCH] bdr: Permit exclusion constraints in bdr extension creation --- contrib/bdr/bdr--0.5.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/contrib/bdr/bdr--0.5.sql b/contrib/bdr/bdr--0.5.sql index 885947ad81..2a441dc1ec 100644 --- a/contrib/bdr/bdr--0.5.sql +++ b/contrib/bdr/bdr--0.5.sql @@ -30,6 +30,9 @@ REVOKE ALL ON FUNCTION pg_stat_get_bdr() FROM PUBLIC; CREATE VIEW pg_stat_bdr AS SELECT * FROM pg_stat_get_bdr(); +-- We must be able to use exclusion constraints for global sequences +SET bdr.permit_unsafe_ddl_commands=true; + CREATE TABLE bdr_sequence_values ( owning_sysid text NOT NULL, @@ -58,6 +61,8 @@ CREATE TABLE bdr_sequence_values ); SELECT pg_catalog.pg_extension_config_dump('bdr_sequence_values', ''); +SET bdr.permit_unsafe_ddl_commands=false; + REVOKE ALL ON TABLE bdr_sequence_values FROM PUBLIC; CREATE INDEX bdr_sequence_values_chunks ON bdr_sequence_values(seqschema, seqname, seqrange); -- 2.39.5