summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--contrib/tcn/Makefile1
-rw-r--r--contrib/tcn/specs/tcn.spec1
2 files changed, 1 insertions, 1 deletions
diff --git a/contrib/tcn/Makefile b/contrib/tcn/Makefile
index f36e6beddd8..68132890005 100644
--- a/contrib/tcn/Makefile
+++ b/contrib/tcn/Makefile
@@ -7,6 +7,7 @@ DATA = tcn--1.0.sql
PGFILEDESC = "tcn - trigger function notifying listeners"
ISOLATION = tcn
+ISOLATION_OPTS = --load-extension=tcn
ifdef USE_PGXS
PG_CONFIG = pg_config
diff --git a/contrib/tcn/specs/tcn.spec b/contrib/tcn/specs/tcn.spec
index 87203981392..fb9e7305fca 100644
--- a/contrib/tcn/specs/tcn.spec
+++ b/contrib/tcn/specs/tcn.spec
@@ -7,7 +7,6 @@
setup
{
- CREATE EXTENSION tcn;
CREATE TABLE mytable (key int PRIMARY KEY, value text);
CREATE TRIGGER tcntrig AFTER INSERT OR UPDATE OR DELETE ON mytable
FOR EACH ROW EXECUTE FUNCTION triggered_change_notification(mychannel);