Re: Deferrable UNIQUE INDEX?

On Jan 3, 2006, at 19:45 , David Fetter wrote:

> Dang!  Everything was going to be kosher at the end of the
> transaction, but I never got a chance.
>
> Is there some way to make the index check INITIALLY DEFERRABLE the way
> a regular column/table constraint could be?

Happy New Year, David!

I've run into this when reorganizing nested-set hierarchies (though  
then it's with integers rather than text). There isn't a way to do  
this directly, as you've found out, but you can use a similar  
workaround. You could prepend a string to the key during the  
permutation, and strip the prefix after permutation is finished.

Not the answer you're looking for, but perhaps you'll be able to use  
this workaround.

Michael Glaesemann
grzm myrealbox com