Re: insertion with trigger failed unexpectedly

From: Anton(dot)Nikiforov(at)loteco(dot)ru
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: insertion with trigger failed unexpectedly
Date: 2004-01-13 13:05:50
Message-ID: 4822677208.20040113160550@loteco.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

RH> And the error message is?
UPDATE Failed... that is it....
I'll try to rewrite my logger to get more diagnostics...
As soon as i'll have some statistics - i'll post it here
But i still cannot understand why it was working fine with a fresh
database (initdb just done) for 1.5 years and when the size become
huge it starts to loose data. I was not modifying tables (only now()
when were migrating to 7.4) nor trigger. Everything is the same as a
year ago.
And when i cleaned some space by removing previous statistic and
vacuuming db - it did not help. But now, when a dropped a trigger -
raw table started to fill normaly.

>> I was also testing inserts without a trigger. With my insertion tool
>> everything was fine, but with inserting from text file via psql
>> utility there were looses if the number of INSERTs was largger than
>> 100 items.
>> For information the same happened on my 7.3.2, then 7.3.4 and now 7.4.

RH> There must be an error message, surely?
No message. I know it is strange, but belive me, i'm woorking with
postgresql since 6.5 or something like this and this traffic database
coming from that time.
Maybe i do not know something where to get additional error codes, but
looks like i read documentation 20 times at least.

Regards,
Anton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Witney 2004-01-13 13:37:32 Re: int8 version of NUMERIC?
Previous Message Chris Travers 2004-01-13 12:56:46 Re: Drawbacks of using BYTEA for PK?