On Mon, Jun 21, 2004 at 10:14:53PM -0400, Tom Lane wrote:
> "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> > [ double evaluation of serial-column default with ]
> >
> > create rule silly_insert_r as on insert to silly do
> > insert into action (item_id,whence)
> > values (new.id,'now');
>
>
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> [ double evaluation of serial-column default with ]
>
> create rule silly_insert_r as on insert to silly do
> insert into action (item_id,whence)
> values (new.id,'now');
The standard answer to this is "use a trigger, not a rule, to copy
insert
The following bug has been logged online:
Bug reference: 1175
Logged by: Joe Carlson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.2
Operating system: linux
Description:insert rule action with defaults
Details:
I realize this was discussed 2 years ag