Re: [GENERAL] Question on Rules

2012-04-07 Thread Michael Gould 
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

Re: [GENERAL] Question on Rules

2012-02-20 Thread mgould 
 text/html; charset="utf-8": Unrecognized 
inline: top.letterhead

Re: [GENERAL] Question on Rules

2012-02-20 Thread John R Pierce 

On 02/20/12 9:07 AM, mgo...@isstrucksoftware.net wrote:

Are rules deprecated?


rules are very tricky, and primarily exist now for internal use.



--
john r pierceN 37, W 122
santa cruz ca mid-left coast


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

Re: [GENERAL] Question on Rules

2012-02-19 Thread David Johnston 
-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

[GENERAL] Question on Rules

2012-02-18 Thread mgould 
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general