Thanks I will change to a trigger Best Regards Mike Gould Sent from Samsung mobile David Johnston <polobo@xxxxxxxxx> wrote: >-----Original Message----- >From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of mgould@xxxxxxxxxxxxxxxxxxxx >Sent: Saturday, February 18, 2012 5:17 AM >To: pgsql-general@xxxxxxxxxxxxxx >Subject: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
