Subject | Broken foreign keys |
---|---|
Author | Rodrigo Goncalves |
Post date | 2004-06-23T20:16:02Z |
Hi all,
in some databases of our clients (3 in about a 100 clients) there has
been a problem of records having values in some fields which do not
match any value in their respective foreign fields. Using gfix on the
database does not raise any error but with a backup/restore the error
becomes clear since it can't recreate the indexes.
Any idea why this happens?
Tks
Rodrigo
in some databases of our clients (3 in about a 100 clients) there has
been a problem of records having values in some fields which do not
match any value in their respective foreign fields. Using gfix on the
database does not raise any error but with a backup/restore the error
becomes clear since it can't recreate the indexes.
Any idea why this happens?
Tks
Rodrigo