"Marc Mamin" <[EMAIL PROTECTED]> writes:
I'd like to ensure that nobody provide the ID in an insert statement when the id is linked to a sequence. I tried it with a trigger, but the id value is fed before the "BEFORE INSERT" test is performed (see below)...
If you have the luxury of re-creating the table (dump, edit schema, reload), you might want to try this:
create table mytable (myid serial primary key constraint mytable_myid_chk check (myid = currval('mytable_myid_seq'), mydata varchar(255), ...);
This will prevent "serial" id field from being arbitrarily manipulated outside the sequence.. There may be an equivalent way using alter table, but on a first look, currval cannot be used to check existing values. Regards Ben K. Developer http://benix.tamu.edu ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
