From 1788f2802034d39421261bd04af82a44cef109ff Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Thu, 19 Jul 2012 11:27:52 +0300 Subject: [PATCH] sql/pgq: Don't tag batch_id_seq as dumpable, pg_dump is broken. This means it's value will be lost during dump+restore. --- sql/pgq/expected/pgq_init_ext.out | 4 ++-- sql/pgq/structure/ext_postproc.sql | 3 ++- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/sql/pgq/expected/pgq_init_ext.out b/sql/pgq/expected/pgq_init_ext.out index 814ed056..df0cc184 100644 --- a/sql/pgq/expected/pgq_init_ext.out +++ b/sql/pgq/expected/pgq_init_ext.out @@ -15,7 +15,7 @@ create extension pgq from 'unpackaged'; select array_length(extconfig, 1) from pg_catalog.pg_extension where extname = 'pgq'; array_length -------------- - 7 + 6 (1 row) select pgq.create_queue('testqueue2'); @@ -44,6 +44,6 @@ create extension pgq; select array_length(extconfig, 1) from pg_catalog.pg_extension where extname = 'pgq'; array_length -------------- - 7 + 6 (1 row) diff --git a/sql/pgq/structure/ext_postproc.sql b/sql/pgq/structure/ext_postproc.sql index dbe92b7d..5c945e87 100644 --- a/sql/pgq/structure/ext_postproc.sql +++ b/sql/pgq/structure/ext_postproc.sql @@ -8,5 +8,6 @@ SELECT pg_catalog.pg_extension_config_dump('pgq.subscription', ''); SELECT pg_catalog.pg_extension_config_dump('pgq.event_template', ''); SELECT pg_catalog.pg_extension_config_dump('pgq.retry_queue', ''); -SELECT pg_catalog.pg_extension_config_dump('pgq.batch_id_seq', ''); +---- pg_dump is broken and cannot handle dumpable sequences +-- SELECT pg_catalog.pg_extension_config_dump('pgq.batch_id_seq', ''); -- 2.39.5