From 8cf35b2699fa184b237650555a16bad04d07b13b Mon Sep 17 00:00:00 2001 From: Petr Jelinek Date: Mon, 28 Jul 2014 17:41:33 +0200 Subject: [PATCH] bdr: support start param in CREATE SEQUENCE USING bdr. (RT-#37861) --- bdr_seq.c | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/bdr_seq.c b/bdr_seq.c index d71ddc0a33..d1f1394327 100644 --- a/bdr_seq.c +++ b/bdr_seq.c @@ -175,7 +175,8 @@ const char *start_elections_sql = " WHERE\n" " max_val.seqschema = pg_namespace.nspname\n" " AND max_val.seqname = pg_class.relname\n" -" ), 0) AS current_max\n" +" ), (SELECT start_value FROM pg_sequence_parameters(pg_class.oid)))\n" +" AS current_max\n" " FROM\n" " pg_class\n" " JOIN pg_namespace ON (pg_class.relnamespace = pg_namespace.oid)\n" @@ -195,7 +196,8 @@ const char *start_elections_sql = " AND pg_class.relam = (SELECT oid FROM pg_seqam WHERE seqamname = 'bdr')\n" " GROUP BY\n" " pg_class.relname,\n" -" pg_namespace.nspname\n" +" pg_namespace.nspname,\n" +" pg_class.oid\n" " HAVING\n" " count(bdr_sequence_values) <= 5\n" "),\n" -- 2.39.5