Re: [BUGS] BUG #1175: insert rule action with defaults

2004-06-27 Thread Joe Carlson
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'); > >

Re: [BUGS] BUG #1175: insert rule action with defaults

2004-06-21 Thread Tom Lane
"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

[BUGS] BUG #1175: insert rule action with defaults

2004-06-21 Thread PostgreSQL Bugs List
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