Re: Triggers or primary key constraints

Stephen Manga wrote: > > Dhanesh, > > Have you tried creating a primary key instead of the unique index. The primary > key is a constraint and constraint checking is done by the engine. I think this > will keep your uniqueness without the locking problem. Perhaps some one else > can comment. Well constraints are actually implemented using locks. So that isn't going to help you. I don't remember any details of the engine, but if this is IDS make sure the tables are using ROW level locking. That could sort the problem. Also look at the SET LOCK MODE command. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+