Re: [GENERAL] NEW in after insert trugger contained incorrect data

2014-11-17 Thread Brilliantov Kirill Vladimirovich
; END IF; ELSE RETURN FALSE; END IF; END;$BODY$ LANGUAGE plpgsql VOLATILE SECURITY DEFINER COST 100; -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] NEW in after insert trugger contained incorrect data

2014-11-17 Thread Brilliantov Kirill Vladimirovich
your SELECT, the data loss will be completely silent). Hello, Jim! Table trassa.cpu_load_stat have field id, it is a primary key. I rewrite trigger with using loop, unfortunately thi not solve problem. -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (

Re: [GENERAL] NEW in after insert trugger contained incorrect data

2014-11-14 Thread Brilliantov Kirill Vladimirovich
_cpu_load_stat_trigger AFTER INSERT ON trassa.cpu_load_stat FOR EACH ROW EXECUTE PROCEDURE trassa.update_cpu_load_stat(); Thank you and excuse my big message. -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] NEW in after insert trugger contained incorrect data

2014-11-14 Thread Brilliantov Kirill Vladimirovich
Adrian Klaver wrote on 11/14/2014 05:15 PM: Actually I think there is in the table the trigger is on. From the original post: SQL statement "INSERT INTO trassa.cpu_load (device, device_timestamp, cpu, value) VALUES(5,'1970-01-02 06:02:38',0,6),(5,'1970-01-02 06:02:38',1,0),(5,'1970-01-02 06:02:

Re: [GENERAL] NEW in after insert trugger contained incorrect data

2014-11-14 Thread Brilliantov Kirill Vladimirovich
TICE USING MESSAGE = '*** END ***: ' || TG_NAME; RETURN NULL; END; $BODY$ LANGUAGE plpgsql VOLATILE SECURITY DEFINER COST 100; -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] NEW in after insert trugger contained incorrect data

2014-11-14 Thread Brilliantov Kirill Vladimirovich
at EXECUTE statement NOTICE: *** START ***: (38,5,0,6,"1970-01-02 06:02:38","2014-11-14 13:38:04.94" ,6,"2014-11-14 13:38:04.94",6,"1970-01-02 06:02:38","2014-11-14 13:38:04.94",6,1) Last START incorrect because NEW contained data from preview

Re: [GENERAL] After insert trigger not work

2014-11-13 Thread Brilliantov Kirill Vladimirovich
DELETE NO ACTION ) -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] After insert trigger not work

2014-11-13 Thread Brilliantov Kirill Vladimirovich
any error, but data in trassa.ram_free_stat not updated. Can you help me solve this problem? Thank you and excuse me for my bad english. -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] undefined struct 'pg_conn' on Windows7

2014-10-29 Thread Brilliantov Kirill Vladimirovich
Albe Laurenz wrote on 10/29/2014 11:57 AM: Any chance that you use a variable of type "PGconn" when it should be "PGconn*" ? Hello and thank you for your reply! Yes, you right, problem solved after change PGconn on PGconn*. -- Best regards, Brilliantov Kirill Vladimir

[GENERAL] undefined struct 'pg_conn' on Windows7

2014-10-29 Thread Brilliantov Kirill Vladimirovich
get error "uses undefined struct 'pg_conn'". How can I solve this problem? Thank you and excuse me for my bad english. -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] Build libpq on Win7 failed with error "U1045: spawn failed"

2014-10-28 Thread Brilliantov Kirill Vladimirovich
ql-9.3.5-3-windows-x64.exe file, for build postgresql-9.3.4.tar.bz2. -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Build libpq on Win7 failed with error "U1045: spawn failed"

2014-10-28 Thread Brilliantov Kirill Vladimirovich
E=user USERPROFILE=C:\Users\user windir=C:\Windows windows_tracing_flags=3 windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log Can you help me solve this problem? Thank you and excuse me for my bad english. -- Best regards, Brilliantov Kirill Vladimirovich -- Sent via pgsql-general m