Re: Rules with sequence columns - Mailing list pgsql-sql

From Tom Lane
Subject Re: Rules with sequence columns
Date
Msg-id 26419.1175098625@sss.pgh.pa.us
Whole thread Raw
In response to Rules with sequence columns  (Ray Madigan <ray@madigans.org>)
List pgsql-sql
Ray Madigan <ray@madigans.org> writes:
> Does anyone have any suggestion?

Use a trigger to propagate the data to the other table.  You can't make
this work reliably with a rule, because rules are macros and hence
inherently subject to double-evaluation problems when dealing with
volatile functions.
        regards, tom lane


pgsql-sql by date:

Previous
From: Ray Madigan
Date:
Subject: Rules with sequence columns
Next
From: Andreas Kretschmer
Date:
Subject: Re: union with count?