Re: [GENERAL] After insert trigger not work

On 11/13/2014 04:27 AM, Brilliantov Kirill Vladimirovich wrote: Hello! I use postgre-9.3.5 on windows7 x64. Trigger should update data in table: CREATE TABLE trassa.ram_free_stat ( id serial NOT NULL, device integer NOT NULL, min_value integer NOT NULL, avg_value integer NOT NULL DEFA

Re: [GENERAL] After insert trigger not work

Melvin Davidson wrote on 11/13/2014 05:29 PM: s for I suspect your problem is because you have 6 columns that are NOT NULL, but on INSERT you are only supplying values for 4 columns plus the id(serial). Therefore, the INSERT will fail. Perhaps if you supplied a value for last_update you it will w

[GENERAL] After insert trigger not work

Hello! I use postgre-9.3.5 on windows7 x64. Trigger should update data in table: CREATE TABLE trassa.ram_free_stat ( id serial NOT NULL, device integer NOT NULL, min_value integer NOT NULL, avg_value integer NOT NULL DEFAULT 0, max_value integer NOT NULL, last_update timestamp without