Re: [BUGS] BUG #1447: Sometimes rules don't work

2005-01-31 Thread Olleg Samoylov
Tom Lane wrote: "Olleg Samoylov" <[EMAIL PROTECTED]> writes: create rule history_i as on insert to history do (update abonent set money=money+new.money where abonent=new.abonent); insert into history (abonent,money) select abonent,-(money.money+5) as pay from ( select abonent,sum(money) as mone

Re: [BUGS] BUG #1447: Sometimes rules don't work

2005-01-29 Thread Tom Lane
"Olleg Samoylov" <[EMAIL PROTECTED]> writes: > create rule history_i as on insert to history do (update abonent set > money=money+new.money where abonent=new.abonent); > insert into history (abonent,money) select abonent,-(money.money+5) as pay > from > ( select abonent,sum(money) as money fro

[BUGS] BUG #1447: Sometimes rules don't work

2005-01-29 Thread Olleg Samoylov
The following bug has been logged online: Bug reference: 1447 Logged by: Olleg Samoylov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6, 8.0.0 Operating system: x86_64-pc-linux-gnu, compiled by GCC x86_64-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-6) Description: