From 7398353c441699acc8b6ed38e221e40e30196208 Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Wed, 10 Mar 2010 21:54:30 +1300
Subject: primary keys and unique indexes working in postgres

---
 lib/pgsqlschema.php | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

(limited to 'lib/pgsqlschema.php')

diff --git a/lib/pgsqlschema.php b/lib/pgsqlschema.php
index a4ebafae4..825241902 100644
--- a/lib/pgsqlschema.php
+++ b/lib/pgsqlschema.php
@@ -171,12 +171,10 @@ class PgsqlSchema extends Schema
         }
 
         if (count($primary) > 0) { // it really should be...
-            $sql .= ",\nconstraint primary key (" . implode(',', $primary) . ")";
+            $sql .= ",\n primary key (" . implode(',', $primary) . ")";
         }
 
-        foreach ($uniques as $u) {
-            $sql .= ",\nunique index {$name}_{$u}_idx ($u)";
-        }
+
 
         foreach ($indices as $i) {
             $sql .= ",\nindex {$name}_{$i}_idx ($i)";
@@ -184,6 +182,10 @@ class PgsqlSchema extends Schema
 
         $sql .= "); ";
 
+
+        foreach ($uniques as $u) {
+            $sql .= "\n CREATE index {$name}_{$u}_idx ON {$name} ($u); ";
+        }
         $res = $this->conn->query($sql);
 
         if (PEAR::isError($res)) {
-- 
cgit v1.2.3