Skip to content

Commit b609f5b

Browse files
committed
Adjust tests to work with 9.4
1 parent 6fae0fa commit b609f5b

File tree

4 files changed

+28
-1
lines changed

4 files changed

+28
-1
lines changed

Makefile

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -48,6 +48,7 @@ ifeq ($(PGVER),94)
4848
PG_CPPFLAGS += $(addprefix -I,$(realpath $(srcdir)/compat))
4949
OBJS += $(realpath $(srcdir)/compat/pglogical_compat.o)
5050
DATA += compat/pglogical_origin.control compat/pglogical_origin--1.0.0.sql
51+
REGRESS = preseed infofuncs init_fail init preseed_check basic extended toasted replication_set add_table matview primary_key foreign_key functions copy drop
5152
REGRESS += --dbname=regression
5253
SCRIPTS_built += pglogical_dump/pglogical_dump
5354
SCRIPTS += pglogical_dump/pglogical_dump

expected/init.out

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -29,6 +29,12 @@ GRANT ALL ON SCHEMA public TO nonsuper;
2929
\c :provider_dsn
3030
SET client_min_messages = 'warning';
3131
CREATE EXTENSION IF NOT EXISTS pglogical;
32+
DO $$
33+
BEGIN
34+
IF (SELECT setting::integer/100 FROM pg_settings WHERE name = 'server_version_num') = 904 THEN
35+
CREATE EXTENSION IF NOT EXISTS pglogical_origin;
36+
END IF;
37+
END;$$;
3238
SELECT * FROM pglogical.create_node(node_name := 'test_provider', dsn := 'dbname=regression user=super');
3339
create_node
3440
-------------
@@ -38,6 +44,12 @@ SELECT * FROM pglogical.create_node(node_name := 'test_provider', dsn := 'dbname
3844
\c :subscriber_dsn
3945
SET client_min_messages = 'warning';
4046
CREATE EXTENSION IF NOT EXISTS pglogical;
47+
DO $$
48+
BEGIN
49+
IF (SELECT setting::integer/100 FROM pg_settings WHERE name = 'server_version_num') = 904 THEN
50+
CREATE EXTENSION IF NOT EXISTS pglogical_origin;
51+
END IF;
52+
END;$$;
4153
SELECT * FROM pglogical.create_node(node_name := 'test_subscriber', dsn := 'dbname=postgres user=super');
4254
create_node
4355
-------------

pglogical_sync.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -452,8 +452,8 @@ pglogical_sync_worker_cleanup(PGLogicalSubscription *sub)
452452
if (replorigin_session_origin != InvalidRepOriginId)
453453
{
454454
replorigin_session_reset();
455-
replorigin_drop(replorigin_session_origin);
456455
replorigin_session_origin = InvalidRepOriginId;
456+
replorigin_drop(replorigin_session_origin);
457457
}
458458
}
459459

sql/init.sql

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -32,12 +32,26 @@ GRANT ALL ON SCHEMA public TO nonsuper;
3232
SET client_min_messages = 'warning';
3333
CREATE EXTENSION IF NOT EXISTS pglogical;
3434

35+
DO $$
36+
BEGIN
37+
IF (SELECT setting::integer/100 FROM pg_settings WHERE name = 'server_version_num') = 904 THEN
38+
CREATE EXTENSION IF NOT EXISTS pglogical_origin;
39+
END IF;
40+
END;$$;
41+
3542
SELECT * FROM pglogical.create_node(node_name := 'test_provider', dsn := 'dbname=regression user=super');
3643

3744
\c :subscriber_dsn
3845
SET client_min_messages = 'warning';
3946
CREATE EXTENSION IF NOT EXISTS pglogical;
4047

48+
DO $$
49+
BEGIN
50+
IF (SELECT setting::integer/100 FROM pg_settings WHERE name = 'server_version_num') = 904 THEN
51+
CREATE EXTENSION IF NOT EXISTS pglogical_origin;
52+
END IF;
53+
END;$$;
54+
4155
SELECT * FROM pglogical.create_node(node_name := 'test_subscriber', dsn := 'dbname=postgres user=super');
4256

4357
SELECT * FROM pglogical.create_subscription(

0 commit comments

Comments
 (0)