From: Alan Knowles Date: Tue, 7 Oct 2014 10:50:08 +0000 (+0800) Subject: pgsql/schema_create_table_statement.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=457d80abbdcbd38024e61620bccd67b5c95ffc4a pgsql/schema_create_table_statement.sql --- diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql index 1fc80068..c1960a66 100644 --- a/pgsql/schema_create_table_statement.sql +++ b/pgsql/schema_create_table_statement.sql @@ -58,7 +58,8 @@ BEGIN ELSE v_table_ddl:= 'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| ' ADD COLUMN ' || v_table_ddl||';'; END IF; - + -- what does this do? + IF column_record.attnum <= column_record.max_attnum THEN v_table_ddl:=v_table_ddl||chr(10)|| ' '||column_record.column_name||' '||column_record.column_type||' '||column_record.column_default_value||' '||column_record.column_not_null;