Re: Constraint name constraint-name already exists.

From: "Rok Vizintin" <rok.vizintin@mais.si> > >I'm using WinNT 4.0 sp 5 and Informix 7.3x. > >When I export database there are "not null" constraint names added to >export sql (ie. "station_id nchar(16) not null constraint >"informix".n173_199," see the example below). >So when I importing the error -625 appears. Then I manually delete the >constratint names from SQL and import the database again. Yep. >WRONG sql: >create table "informix".printers_avail > ( > station_id nchar(16) not null constraint "informix".n173_199, > printer_port nchar(10) not null constraint "informix".n173_200, > device_name nchar(40) not null constraint "informix".n173_201, > primary key (station_id,device_name) constraint >"informix".pk_printers_avail > ) extent size 16 next size 16 lock mode row; >revoke all on "informix".printers_avail from "public";> >RIGHT sql: >create table "informix".printers_avail > ( > station_id nchar(16) not null , > printer_port nchar(10) not null , > device_name nchar(40) not null , > primary key (station_id,device_name) constraint >"informix".pk_printers_avail > ) extent size 16 next size 16 lock mode row; >revoke all on "informix".printers_avail from "public"; Your question being? You haven't done anything wrong, this is the (incredibly irritating) way it normally goes, unfortunately. :-( ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com