Le vendredi 04 juin 2004, David Brady a �crit... > I've a simple table with only a single primary key constraint - why > would the loader complain of "SQL error 250 = Duplicate secondary > key:INDEX001 (error position: 1) " if i've specified ignore duplicates? > See below for table def and script. Advice appreciated:
> create table financial_event > ( > id VARCHAR (50) unique not null , > SQL error 250 = Duplicate secondary key:INDEX001 (error position: 1) I think that your pk is a SYSKEY, primary key defined by maxdb, because you do not create it. But you have created an unamed index (id) with UNIQUE, and maxdb name it INDEX001. Try to use ID VARCHAR(50) NOT NULL PRIMARY KEY, -- jm -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
