From bdc93f0de835a3ef32c89965eb40c8d789543303 Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane <greg@users.mediawiki.org>
Date: Mon, 14 Feb 2011 00:36:36 +0000
Subject: [PATCH] Not sure I like the DROP stuff here, but let's exclude it
 from this script.

---
 maintenance/postgres/compare_schemas.pl | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/maintenance/postgres/compare_schemas.pl b/maintenance/postgres/compare_schemas.pl
index 7e3cdf719c..18210fcf5e 100644
--- a/maintenance/postgres/compare_schemas.pl
+++ b/maintenance/postgres/compare_schemas.pl
@@ -94,7 +94,7 @@ sub parse_sql {
 		next if /^\s*\-\-/ or /^\s+$/;
 		s/\s*\-\- [\w ]+$//;
 		chomp;
-
+	
 		if (/CREATE\s*TABLE/i) {
 			if (m{^CREATE TABLE /\*_\*/(\w+) \($}) {
 				$table = $1;
@@ -179,6 +179,10 @@ while (<$newfh>) {
 	next if /^CREATE TRIGGER/ or /^  FOR EACH ROW/;
 	next if /^INSERT INTO/ or /^  VALUES \(/;
 	next if /^ALTER TABLE/;
+	next if /^DROP SEQUENCE/;
+	next if /^DROP FUNCTION/;
+
+
 	chomp;
 
 	if (/^\$mw\$;?$/) {
-- 
2.20.1