woodsmailbox wrote:

> I know deferred constraints would solve it, but is there any other way in the absence of it? Assigning an out-of-domain value is not acceptable, since it breaks the domain definition. Thanks.

Maybe you could swap (update) values of all other columns and leave the
unique column as it is?

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com