Re: [GENERAL] recursive inner trigger call

2011-12-01 Thread Red Light
Hi David, Thanks a lot. From: David Johnston To: 'Red Light' ; "'Gauthier, Dave'" Cc: pgsql-general@postgresql.org Sent: Thursday, December 1, 2011 8:31 PM Subject: RE: [GENERAL] recursive inner trigger call CREATE OR RE

Re: [GENERAL] recursive inner trigger call

2011-12-01 Thread Red Light
Hi Dave, when i use before trigger , nothing happen; i mean no cumputation is done  (and when i start tu duplicate the same data just by mistake ...) i got the same error. From: "Gauthier, Dave" To: Red Light ; "pgsql-general@postgres

[GENERAL] recursive inner trigger call

2011-12-01 Thread Red Light
Hi guys, i got the following problematic : i got a table called bv that have some 'entry data' and i have another column that need to be calculated and put back in the table: here is my table: CREATE TABLE public.bv (   id_bv integer NOT NULL,   c_vmax_actuel real,   d_capacite_barrages_new