projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
d219e6b
)
pgsql/schema_create_table_statement.sql
author
Alan Knowles
<alan@roojs.com>
Tue, 7 Oct 2014 10:49:23 +0000
(18:49 +0800)
committer
Alan Knowles
<alan@roojs.com>
Tue, 7 Oct 2014 10:49:23 +0000
(18:49 +0800)
pgsql/schema_create_table_statement.sql
patch
|
blob
|
history
diff --git
a/pgsql/schema_create_table_statement.sql
b/pgsql/schema_create_table_statement.sql
index
b41e6c7
..
1fc8006
100644
(file)
--- a/
pgsql/schema_create_table_statement.sql
+++ b/
pgsql/schema_create_table_statement.sql
@@
-56,7
+56,7
@@
BEGIN
IF column_record.attnum = 1 THEN
v_table_ddl:='CREATE TABLE '||column_record.schema_name||'.'||column_record.table_name||' ();';
ELSE
- v_table_ddl:=
v_table_ddl||',
';
+ v_table_ddl:=
'ALTER TABLE '||column_record.schema_name||'.'||column_record.table_name|| ' ADD COLUMN ' || v_table_ddl||';
';
END IF;
IF column_record.attnum <= column_record.max_attnum THEN