From 98f74f2f8ee4e06a937ab0443aca1ab63885990c Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane
Date: Thu, 6 Oct 2011 15:04:01 -0400
Subject: Use the full path when getting sequence information for same_schema.
 Thanks to Cindy Wise for the bug report.

---
 check_postgres.pl | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'check_postgres.pl')

diff --git a/check_postgres.pl b/check_postgres.pl
index ccf62a072..a0a4f6589 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -730,7 +730,8 @@ WHERE t.typtype NOT IN ('b','c')},
     sequence => {
         SQL       => q{
 SELECT c.*, nspname||'.'||relname AS name, quote_ident(usename) AS owner,
-  quote_ident(relname) AS safename, quote_ident(nspname) AS schema
+  (quote_ident(nspname)||'.'||quote_ident(relname)) AS safename,
+quote_ident(nspname) AS schema
 FROM pg_class c
 JOIN pg_user u ON (u.usesysid = c.relowner)
 JOIN pg_namespace n ON (n.oid = c.relnamespace)
-- 
cgit v1.2.3