Search Postgresql Archives

Question on Rules

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux