From 096d7aa00064a2474bb20106f13decc6b19f488a Mon Sep 17 00:00:00 2001 From: Ian Barwick Date: Thu, 9 Jul 2015 15:30:24 +0900 Subject: [PATCH] Only install bdr.bdr_internal_sequence_reset_cache() in BDR mode bdr_seq.c not compiled for UDR; attempting to create this function in UDR mode prevents the extension from being installed. --- extsql/bdr--0.10.0.5--0.10.0.6.sql | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) diff --git a/extsql/bdr--0.10.0.5--0.10.0.6.sql b/extsql/bdr--0.10.0.5--0.10.0.6.sql index 3151695cee..9d2d854bd8 100644 --- a/extsql/bdr--0.10.0.5--0.10.0.6.sql +++ b/extsql/bdr--0.10.0.5--0.10.0.6.sql @@ -2,8 +2,13 @@ SET LOCAL search_path = bdr; SET bdr.permit_unsafe_ddl_commands = true; SET bdr.skip_ddl_replication = true; -CREATE OR REPLACE FUNCTION bdr.bdr_internal_sequence_reset_cache(seq regclass) -RETURNS void LANGUAGE c AS 'MODULE_PATHNAME' STRICT; +DO $$ +BEGIN + IF bdr.bdr_variant() = 'BDR' THEN + CREATE OR REPLACE FUNCTION bdr.bdr_internal_sequence_reset_cache(seq regclass) + RETURNS void LANGUAGE c AS 'MODULE_PATHNAME' STRICT; + END IF; +END$$; RESET bdr.permit_unsafe_ddl_commands; RESET bdr.skip_ddl_replication; -- 2.39.5