Re: ISAM Error Duplicate Value

Ian van der Poel in article <4gh2v5$8c9$1@sydney.DIALix.oz.au> wrote: > > When adding a referential constraint to certain tables I get > the following error > > ISAM Error Duplicate value for record with unique key > > The error appears when I am doing a DBSCHEMA or EBEXPORT of the database > > If I drop the constraint the error disappears > This occurs on some tables but not all. > > Has anyone seen this. > I am running Online version 5.01 on Solaris 2.3 > > Thanks > Ian van der Poel NSW Dept. of Transport > -- > NSW Department of Transport > Level 12, 227 Elizabeth Street, Sydney, NSW, Australia 2000 I have the same problem (and this is an INFORMIX bug, i guess). I noted this occurs on the databases with LOG MODE ANSI only. When the database log mode is switched to regular logging, the problem goes away. If the database logging mode modification is not acceptable, DBSCHEMA will always fail with ISAM error as above. However, maybe someone from INFORMIX, Inc. could say other words ... Take care, Pavel <pavel@cso.spb.su>