summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGreg Sabino Mullane2010-02-01 22:51:33 +0000
committerGreg Sabino Mullane2010-02-01 22:51:33 +0000
commit543cf9d1f39177a5b07643d4c86b5377829559a5 (patch)
tree53b2b04afe006271b57d16e427842182a629252b
parentdce5668693855c2e15ec3e18347a5b88ebaa5583 (diff)
Fitler out generic constraints in other place as well.
-rwxr-xr-xcheck_postgres.pl13
1 files changed, 8 insertions, 5 deletions
diff --git a/check_postgres.pl b/check_postgres.pl
index 05353e673..b479d7819 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -4803,12 +4803,15 @@ SQL
next;
}
my ($cschema,$cname,$tschema,$tname,$col,$cdef) = ($6,$7,$2,$3,$4,$8);
- if (exists $thing{$x}{colconstraints}{"$cschema.$cname"}) {
- my @oldcols = split / / => $thing{$x}{colconstraints}{"$cschema.$cname"}->[1];
- push @oldcols => $col;
- $col = join ' ' => sort @oldcols;
+ ## No sense in grabbing "generic" constraints
+ if ($cname !~ /^\$\d+$/o) {
+ if (exists $thing{$x}{colconstraints}{"$cschema.$cname"}) {
+ my @oldcols = split / / => $thing{$x}{colconstraints}{"$cschema.$cname"}->[1];
+ push @oldcols => $col;
+ $col = join ' ' => sort @oldcols;
+ }
+ $thing{$x}{colconstraints}{"$cschema.$cname"} = ["$tschema.$tname", $col, $cdef];
}
- $thing{$x}{colconstraints}{"$cschema.$cname"} = ["$tschema.$tname", $col, $cdef];
}
}
}