On Wed, Dec 9, 2009 at 2:35 AM, beamends
<..hidden..> wrote:
Hi all,
I've mentioned this before, but it is now becoming a real problem.
When Saving a part with the Vendor info filled in it is taking
increasingly long for for the save not to produce this error:
"DBD::Pg::st execute failed: ERROR: duplicate key violates unique
constraint "partsvendor_pkey" at LedgerSMB/IC.pm line 529.
Error!
INSERT INTO partsvendor
(vendor_id, parts_id,
partnumber, lastcost,
leadtime, curr)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: duplicate key violates unique constraint "partsvendor_pkey"
"
try:
SELECT setval('partsvendor_entry_id_seq', max(entry_id)) from partsvendor;
There seems to be no rhyme nor reason, sometimes it works first time,
every time for a while, other (now most) times it can take ages.
The record so far is 102 attempts, and just changing a spelling mistake
can now take 20 mins!
When saving a new part, the same happens but the part record is saved
without the vendor info - the part complete records then have to be
deleted manually.
The only trend is that it is getting much worse as the dbase grows!
If necessary I can supply a back-up of our dbase for testing - I was
hoping that I could hang on for 1.3, but this is becoming a real
problem.
Cheers
Richard
--
I have become....... comfortably numb.
------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users