Hi Do it in two steps. First load the table without FK and then apply an ALTER operation. regards, Martin On 11/20/13 1:37 PM, Treffer, Arian wrote:

Hello,

I want to import data into a table which has a foreign key to itself:

CREATE TABLE "Type" ( "id" INT NOT NULL , "name" VARCHAR(255) NOT NULL , "file" VARCHAR(255) NULL , "componentTypeId" INT NULL , PRIMARY KEY ("id") , CONSTRAINT "fk_Type_componentType" FOREIGN KEY ("componentTypeId" ) REFERENCES "Type" ("id" ) ON DELETE NO ACTION ON UPDATE NO ACTION) ;

Now, if I try to import some data, eg:

0;a;a;NULL 1;b;b;0

the second line causes an error:

sql>COPY INTO "Type" FROM 'C:/data.csv' USING DELIMITERS ';','\n'; INSERT INTO: FOREIGN KEY constraint 'Type.fk_Type_componentType' violated

What is the correct way to import the data? Since I have a lot of tables, I would rather not have to drop and re-create all constraints.

Best regards, Arian _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list