"Duplicated key" errors after importing schema
"Martin Cordova" <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Hello: I am using MaxDB 7.6.0.34. I have noticed that after importing a schema, I have to do a full backup otherwise the data will be read only. No problem with that. What's really a problem is that If I use a sequence to feed a primary key during inserts, the first time an insert is executed, i receive a "duplicated key...." error, which happens only the first time. After that inserts proceed normally. Is there a way to avoid this behaviour? I am importing the schema using something like: TABLELOAD USER CATALOG INSTREAM '/dbbackup/catalog.dat' DATA INSTREAM '/dbbackup/data.dat' Best regards, Martin -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[email protected]