From 362890ebe8550f63fa48511f84997d4ff6dc94b3 Mon Sep 17 00:00:00 2001
From: glynastill
Date: Thu, 10 Sep 2015 10:53:43 +0100
Subject: Fix trigger check in check_same_schema to ignore deferrable unique
 constraint triggers

These triggers have a name containting the triggers oid which mismatches on logical replicas; so to exclude these just ensure tgconstrindid is zero.
---
 check_postgres.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'check_postgres.pl')

diff --git a/check_postgres.pl b/check_postgres.pl
index 4de0d414f..f3767348f 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -1102,7 +1102,7 @@ JOIN pg_proc p ON (p.oid = t.tgfoid)
 JOIN pg_namespace n3 ON (n3.oid = p.pronamespace)
 LEFT JOIN pg_class c2 ON (c2.oid = t.tgconstrrelid)
 LEFT JOIN pg_namespace n2 ON (n2.oid = c2.relnamespace)
-WHERE t.tgconstrrelid = 0 AND tgname !~ '^pg_'},
+WHERE t.tgconstrrelid = 0 AND t.tgconstrindid = 0 AND tgname !~ '^pg_'},
     },
     function => {
         SQL       => q{
-- 
cgit v1.2.3