I receive the "General error;-8030 POS(1) Column must be indexed." when
attempting to add a FK to a table.
The reference column already has the index and the column of the table the
FK is being added to is a primary key column so it is already indexed.
The reason for this action is that a 'restrict delete' FK already present on
the child table failed to prevent the deletion of a record in the parent
table.
For instance:
TABLE A: PK=PKID
TABLE B:
FK=A.PKID ON DELETE RESTRICT
INDEX=A.PKID ASC
CONTAINS 3 RECORDS THAT REFERENCE A.PKID
ISSUE:
DELETE A WHERE PKID=X
Because a restrict FK exists in table B the delete command should not commit
because it leaves orphaned records.
SAPDB v7.3.0.46 on Linux.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
