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
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? |