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