Pman.Gnumeric.js

[Pman.Core] / pgsql / schema_create_table_statement.sql

diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql
index 62ac1b1..72c8bf0 100644 (file)
--- a/pgsql/schema_create_table_statement.sql
+++ b/pgsql/schema_create_table_statement.sql
@@ -91,7 +91,7 @@ BEGIN
                       column_record.iline;
          
     END LOOP;
-
+  v_table_ddl:= v_table_ddl||chr(10);
     -- constraints...
      FOR column_record IN 
         
@@ -111,7 +111,7 @@ BEGIN
          
             v_table_ddl:= v_table_ddl||chr(10)||
                       'ALTER TABLE ' ||v_schema||'.'||p_table_name||' ADD CONSTRAINT ' || column_record.constraint_name ||
-                          ' FOREIGN KEY (' || column_record.column_name || ') REFERENCES ' || column_record.foreign_table_name || '(' || column_record.foreign_column_name || ') MATCH SIMPLE';
+                          ' FOREIGN KEY (' || column_record.column_name || ') REFERENCES ' || column_record.foreign_table_name || '(' || column_record.foreign_column_name || ') MATCH SIMPLE;';
          
     END LOOP;