Re: Problem with unique index

Sharon Cowling <sharon.cowling@sslnz.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