Kbase P125940: Error 7545 when creating references on 4GL table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/20/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Error 7545 when creating references on 4GL table
No matching key defined for the referenced table (7545)
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20103
[JDBC OpenEdge Driver]:No matching key defined for the referenced table (7545)
Using ALTER TABLE PUB.foo ADD COLUMN acct varchar(10) REFERENCES PUB.root(acct)1;
foo and root are 4GL tables
CAUSE:
Enhancement Request# OE00115988
FIX:
This enhancement has not been implemented in the product. SQL does not support creating a foreign key constraint where the referenced table has only 4GL created unique indexes. Progress SQL requires that the referenced table have either a primary or unique key constraint.