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

pgsql/schema_create_table_statement.sql
---

diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql
index b41e6c72..1fc80068 100644
--- a/pgsql/schema_create_table_statement.sql
+++ b/pgsql/schema_create_table_statement.sql
@@ -56,7 +56,7 @@ BEGIN
         IF column_record.attnum = 1 THEN
             v_table_ddl:='CREATE TABLE '||column_record.schema_name||'.'||column_record.table_name||' ();';
         ELSE
-            v_table_ddl:=v_table_ddl||',';
+            v_table_ddl:= 'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| ' ADD COLUMN ' || v_table_ddl||';';
         END IF;
 
         IF column_record.attnum <= column_record.max_attnum THEN