From: Alan Knowles Date: Tue, 7 Oct 2014 11:06:18 +0000 (+0800) Subject: pgsql/schema_create_table_statement.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=f388d4fbaff4882638f66bea1251fea734946dd9 pgsql/schema_create_table_statement.sql --- diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql index 751e2504..09df8f0b 100644 --- a/pgsql/schema_create_table_statement.sql +++ b/pgsql/schema_create_table_statement.sql @@ -4,6 +4,7 @@ $BODY$ DECLARE v_table_ddl text; column_record record; + v_colname text; BEGIN FOR column_record IN SELECT @@ -60,6 +61,7 @@ BEGIN END IF; -- what does this do? + 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||