Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0DKrkB56234 for ; Sun, 13 Jan 2002 15:53:46 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g0DKrGg28332; Sun, 13 Jan 2002 15:53:16 -0500 (EST) To: Sharon Cowling cc: pgsql-sql@postgresql.org Subject: Re: Problem with unique index In-reply-to: <200201132019.g0DKJLv15052@lambton.sslnz.com> References: <200201132019.g0DKJLv15052@lambton.sslnz.com> Comments: In-reply-to Sharon Cowling message dated "Sun, 13 Jan 2002 20:23:00 +0000" Date: Sun, 13 Jan 2002 15:53:16 -0500 Message-ID: <28329.1010955196@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200201/111 X-Sequence-Number: 6200 Sharon Cowling 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