Re: Problem with unique index

Sharon Cowling <sharon(dot)cowling(at)sslnz(dot)com> writes:

> INSERT INTO person
> VALUES
> (new.person_id, new.firstname, new.lastname, new.dob, new.street, new.suburb, new.city, new.homephone, new.workphone, new.mobile, new.type, new.date_approved, new.approved_by, new.vehicle_type, new.vehicle_rego, new.notes);

This is going to insert into the first N columns of person, and if I'm
counting correctly that means "new.notes" is going to wind up in the
drivers_licence column. Perhaps you want to call out the target columns
explicitly in the INSERT command.

regards, tom lane