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