From f388d4fbaff4882638f66bea1251fea734946dd9 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 7 Oct 2014 19:06:18 +0800 Subject: [PATCH] pgsql/schema_create_table_statement.sql --- pgsql/schema_create_table_statement.sql | 2 ++ 1 file changed, 2 insertions(+) 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|| -- 2.39.2