From: Alan Knowles Date: Tue, 7 Oct 2014 10:53:38 +0000 (+0800) Subject: pgsql/schema_create_table_statement.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=94f31f38eef2fa22b0277cd57cdaba2c74a98eb4 pgsql/schema_create_table_statement.sql --- diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql index 379a099f..751e2504 100644 --- a/pgsql/schema_create_table_statement.sql +++ b/pgsql/schema_create_table_statement.sql @@ -63,7 +63,7 @@ BEGIN IF column_record.attnum <= column_record.max_attnum THEN v_table_ddl:= v_table_ddl||chr(10)|| 'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| - ' ADD COLUMN ' ||column_record.column_name||' '||column_record.column_type||' '||column_record.column_default_value||' '||column_record.column_not_null || ";"; + ' ADD COLUMN ' ||column_record.column_name||' '||column_record.column_type||' '||column_record.column_default_value||' '||column_record.column_not_null || ';'; END IF; END LOOP;