From: Alan Knowles <alan@roojs.com>
Date: Tue, 7 Oct 2014 11:38:03 +0000 (+0800)
Subject: pgsql/schema_create_table_statement.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5657e15206c9c9992428b3bc111cf5e2d0d9d755

pgsql/schema_create_table_statement.sql
---

diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql
index 99816ea8..85c497ac 100644
--- a/pgsql/schema_create_table_statement.sql
+++ b/pgsql/schema_create_table_statement.sql
@@ -77,7 +77,7 @@ BEGIN
                 a.attnum,
                 CASE
                     WHEN i.indisprimary THEN 'ALTER TABLE '||v_schema||'.'||p_table_name||' ADD CONSTRAINT ' || c.relname || ' PRIMARY KEY (' || c.attname || ');'
-                    ELSE
+                     
                     WHEN i.indisunique THEN 'CREATE UNIQUE INDEX '|| c.relname || ' ON ' ||v_schema||'.'||p_table_name||' USING btree (' || c.attname || ');'
                     ELSE
                     'CREATE INDEX '|| c.relname || ' ON ' ||v_schema||'.'||p_table_name||' USING btree (' || c.attname || ' );'