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

2014-11-17 Thread Brilliantov Kirill Vladimirovich
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 (pgsql

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

2014-11-17 Thread Brilliantov Kirill Vladimirovich
, 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
-14 13:38:04.94,6,1) Last START incorrect because NEW contained data from previews INSERT. Why and 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

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

2014-11-14 Thread Brilliantov Kirill Vladimirovich
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-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

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

2014-11-14 Thread Brilliantov Kirill Vladimirovich
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
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 subscription

Re: [GENERAL] After insert trigger not work

2014-11-13 Thread Brilliantov Kirill Vladimirovich
ON 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] undefined struct 'pg_conn' on Windows7

2014-10-29 Thread Brilliantov Kirill Vladimirovich
. Unfortunately when I try build project I 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

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 Vladimirovich -- Sent via

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

2014-10-28 Thread Brilliantov Kirill Vladimirovich
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 mailing

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

2014-10-28 Thread Brilliantov Kirill Vladimirovich
-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