Re: [GENERAL] insertion with trigger failed unexpectedly

2004-01-12 Thread Richard Huxton
On Monday 12 January 2004 05:57, [EMAIL PROTECTED] wrote: Dear all, i have a problem with insertion data and running post insert trigger on it. When i'm doing tests - everything is going well, but in production when multiple records being inserted losses happend. OK - there must be

Re: [GENERAL] insertion with trigger failed unexpectedly

2004-01-12 Thread Sai Hertz And Control Systems
Dear Anton Nikiforov, The problem: From the very beginning everything was fine and all records that i was getting from routers were calculated just right. I spent a weeks monitoring and testing my software. Now i have 10.000.000 records in raw table and when i'm inserting data alot of records are

Re: [GENERAL] insertion with trigger failed unexpectedly

2004-01-12 Thread Tom Lane
Richard Huxton [EMAIL PROTECTED] writes: On Monday 12 January 2004 05:57, [EMAIL PROTECTED] wrote: i have a problem with insertion data and running post insert trigger on it. Better post the CREATE TABLE, trigger code and a sample INSERT. And the specific error messages you're getting, and

[GENERAL] insertion with trigger failed unexpectedly

2004-01-11 Thread Anton . Nikiforov
Dear all, i have a problem with insertion data and running post insert trigger on it. Preambula: there is a table named raw: ipsrc | cidr ipdst | cidr bytes | bigint time | timestamp Triggers: daily_trigger AFTER INSERT OR UPDATE ON raw FOR EACH ROW EXECUTE PROCEDURE daily_func() and the