Thanks I will change to a trigger

Best Regards

Mike Gould

Sent from Samsung mobile

David Johnston <pol...@yahoo.com> wrote:

>-----Original Message-----
>From: pgsql-general-ow...@postgresql.org 
>[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of 
>mgo...@isstrucksoftware.net
>Sent: Saturday, February 18, 2012 5:17 AM
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] Question on Rules
>
>I am creating a rule which will copy a record when it is changed to a 
>audittable.  My question is that the first column is a UUID data type with a 
>defined as auditaccessorid uuid DEFAULT
>isscontrib.uuid_generate_v4() NOT NULL,
>
>Right now I've got that set to NULL to allow the parser to "compile". 
>What value should I have in here since I want a newly created UUID?
>
>CREATE RULE log_accessor AS ON UPDATE TO iss.accessor
>    WHERE NEW.* <> OLD.*
>    DO INSERT INTO iss.auditaccessor VALUES (NULL,
>                                          'C',
>                                          new.loaddtlid, 
>                                          new.seqno, 
>                                          new.billable,
>                                          new.payind,
>                                          new.code,
>                                          new.description, 
>                                          new.ref,
>                                          new.tractororcarrierflag, 
>                                          new.tractororcarrierno,
>                                          new.tractorpct,
>                                          new.charge,
>                                          new.type,
>                                          new.checkdate,
>                                          new.checkno,
>                                          new.processed,
>                                          new.itemflag, 
>                                          new.tractortermloc,
>                                          new.cost,
>                                          new.batchno,
>                                          new.editdatetime,  
>                                          new.edituser);
>
>Best Regards,
> 
>Michael Gould
>Intermodal Software Solutions, LLC
>904-226-0978
>
>
>--------------------------------------------------------------------
>
>INSERT INTO table (serial_col1) VALUES (DEFAULT);
>
>Also, I presume you have a good reason for using a RULE instead of a TRIGGER?  
>If not you should default to a TRIGGER for this kind of behavior.
>
>David J.
>
>
>

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to