summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2010-05-15 15:31:54 +1200
committerBrenda Wallace <shiny@cpan.org>2010-05-15 15:31:54 +1200
commita467c0ebbab22a220972e458de0652e523bc12d7 (patch)
treec754e13587371a1f2a944fe0728ecffcec76b416 /lib
parent191752138a26087648dc665595fb9ca566306637 (diff)
caitalise the sql keywords
Diffstat (limited to 'lib')
-rw-r--r--lib/pgsqlschema.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/pgsqlschema.php b/lib/pgsqlschema.php
index 24b847a98..16639ff1b 100644
--- a/lib/pgsqlschema.php
+++ b/lib/pgsqlschema.php
@@ -169,7 +169,7 @@ class PgsqlSchema extends Schema
}
if (count($primary) > 0) { // it really should be...
- $sql .= ",\n primary key (" . implode(',', $primary) . ")";
+ $sql .= ",\n PRIMARY KEY (" . implode(',', $primary) . ")";
}
$sql .= "); ";
@@ -180,7 +180,7 @@ class PgsqlSchema extends Schema
}
foreach ($indices as $i) {
- $sql .= "CREATE index {$name}_{$i}_idx on {$name} ($i)";
+ $sql .= "CREATE index {$name}_{$i}_idx ON {$name} ($i)";
}
$res = $this->conn->query($sql);