Re: unique key problem on update

On Friday 20 September 2013 17:26:58 Thomas Kellerer wrote:
> You need to define the primary key as deferrable:
>
> create table skills_pages
> (
>   sp_id        serial not null,
>   sp_sequence  integer not null,
>   sp_title     character varying(80),
>   sp_narative  text,
>   primary key (sp_id) deferrable
> );

Cheers. I'll look at that. It's actually the second unique index that's the 
problem but I'm guessing I can set that index up as deferrable too.

Hopefully it'll work for mysql too.

-- 
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk