From: Alan Knowles <alan@roojs.com>
Date: Tue, 7 Oct 2014 12:02:02 +0000 (+0800)
Subject: pgsql/schema_create_table_statement.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=1a129cf4bb76191ec679fe0224e2db726c8ccc89

pgsql/schema_create_table_statement.sql
---

diff --git a/pgsql/schema_create_table_statement.sql b/pgsql/schema_create_table_statement.sql
index e7ee570c..62ac1b1a 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 ' || foreign_table_name || '(' || 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;