Re: [SQL] Rules with sequence columns

2007-03-28 Thread Tom Lane
Ray Madigan <[EMAIL PROTECTED]> 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 function

[SQL] Rules with sequence columns

2007-03-28 Thread Ray Madigan
I have the following situation that I would appreciate your input on: I have a table with a column that I use to uniquely identify its rows. The table also has a rule on insert that stores the row identifier into another table for reference at some other point. The table is defined as CREATE