2007/3/29, Martin Cordova <[EMAIL PROTECTED]>:
Hello:I am using MaxDB 7.6.0.34. I have noticed that after importing a schema, If I use a sequence to feed a primary keys 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'
Did you import the sequence or create it differently? I can think of a number of reasons for the behavior you see: - before the schema was exported, the value that would be nextval was manually inserted into the table - a bug in the sequence import or export code - if you manually created the sequence you probably initialized it to a wrong start value Kind regards robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
