UpdateDatabase.php
authorAlan Knowles <alan@roojs.com>
Fri, 6 Dec 2013 07:08:32 +0000 (15:08 +0800)
committerAlan Knowles <alan@roojs.com>
Fri, 6 Dec 2013 07:08:32 +0000 (15:08 +0800)
UpdateDatabase.php

index d7b6879..898ddd1 100644 (file)
@@ -695,7 +695,7 @@ class Pman_Core_UpdateDatabase extends Pman
         $cs->query("
          SELECT
                     'ALTER SEQUENCE '||
-                    WHEN strpos(seq_name, '.') > 0 THEN
+                    CASE WHEN strpos(seq_name, '.') > 0 THEN
                         quote_ident(min(seq_name))
                     ELSE 
                         quote_ident(min(schema_name)) ||'.'|| quote_ident(min(seq_name))