Am Sun, Apr 19, 2026 at 06:54:02AM -0700 schrieb David G. Johnston:
> > > Running that does violate the (non-deferred) UNIQUE
> > > constraint on the table column, however.
>
> You know about deferred constraints, you should use them here. This is one
> of the key use cases motivating their existence.
Indeed. I was of the mistaken impression that UNIQUE
constraints were not deferrable ...
:-)
Works, thanks,
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B