X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=pgsql%2Fschema_create_table_statement.sql;h=09df8f0b051764f15ff7e10e3825777116dd974b;hb=f388d4fbaff4882638f66bea1251fea734946dd9;hp=751e2504b1c68724a4eede7a9f40ee5ed1ad6442;hpb=94f31f38eef2fa22b0277cd57cdaba2c74a98eb4;p=Pman.Core 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||