Better primary key detection
authorJamie Cameron <jcameron@webmin.com>
Fri, 2 Nov 2007 21:55:05 +0000 (21:55 +0000)
committerJamie Cameron <jcameron@webmin.com>
Fri, 2 Nov 2007 21:55:05 +0000 (21:55 +0000)
postgresql/postgresql-lib.pl

index 8158d2a..cf348a4 100644 (file)
@@ -206,7 +206,8 @@ if (&supports_schemas($_[0])) {
 
        # Work out which fields are the primary key
        if (&supports_indexes()) {
-               local ($keyidx) = grep { $_ eq $_[1]."_pkey" }
+               local ($keyidx) = grep { $_ eq $_[1]."_pkey" ||
+                                        $_ eq "pk_".$_[1] }
                                       &list_indexes($_[0]);
                if ($keyidx) {
                        local $istr = &index_structure($_[0], $keyidx);