Received: from falcon.mail.pas.earthlink.net (falcon.mail.pas.earthlink.net [207.217.120.74]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f49Lx8A40332 for ; Wed, 9 May 2001 17:59:08 -0400 (EDT) (envelope-from mdavis@sevainc.com) Received: from SALLY (cpe-66-1-238-71.co.sprintbbd.net [66.1.238.71]) by falcon.mail.pas.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id OAA02437; Wed, 9 May 2001 14:58:46 -0700 (PDT) Received: by localhost with Microsoft MAPI; Wed, 9 May 2001 15:58:45 -0600 Message-ID: <01C0D8A0.ED65E9A0.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Joseph Shraibman'" , "pgsql-sql@postgresql.org" Subject: RE: 'record old is unassigned yet' when using trigger in 7.1.1 Date: Wed, 9 May 2001 15:58:44 -0600 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/66 X-Sequence-Number: 2867 When creating the trigger you need to specify BEFORE UPDATE rather than BEFORE INSERT. -----Original Message----- From: Joseph Shraibman [SMTP:jks@selectacast.net] Sent: Wednesday, May 09, 2001 2:56 PM To: pgsql-sql@postgresql.org Subject: 'record old is unassigned yet' when using trigger in 7.1.1 I have a function used in a trigger that looks like this: begin IF OLD.status <> NEW.status THEN NEW.statchangedate = CURRENT_DATE; END IF; return NEW; end; The problem is when a new row is inserted I get this error message: ERROR: record old is unassigned yet ... and the insert fails. It doesn't matter if the trigger is before or after. -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)