From b7874d8cf5a54d6c262977337c41286416271dab Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 7 Oct 2014 20:14:39 +0800 Subject: [PATCH] pgsql/schema_create_table_statement.sql --- pgsql/schema_create_table_statement.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql index 62ac1b1a..483b5d59 100644 --- a/pgsql/schema_create_table_statement.sql +++ b/pgsql/schema_create_table_statement.sql @@ -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; -- 2.39.2