Gary Stainburn wrote on 20.09.2013 18:30:
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.
Ah, sorry didn't see that ;) but, yes it works the same way:
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),
unique (sp_sequence) deferrable
);
Hopefully it'll work for mysql too.
No, it won't.
MySQL neither has deferrable constraints nor does it evaluate them on statement
level (they are *always* evaluated row-by-row).
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql