#13 Vendor Details Disappear When Parts Record Edited

closed
Chris Travers
None
5
2011-06-24
2008-05-06
beamends
No

1.2.12 on Ubuntu Postgres 8.2

If any field in the Parts record is edited, upon saving
the following results:

BD::Pg::st execute failed: ERROR: duplicate key violates unique constraint "partsvendor_pkey"
Error!

INSERT INTO partsvendor
(vendor_id, parts_id,
partnumber, lastcost,
leadtime, curr)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: duplicate key violates unique constraint "partsvendor_pkey"

All data, except the Vendor info, is actually saved, but all the vendor info is lost.

Very occasionaly the save does work, but there appears to be no rhyme nor reason.

Richard

Discussion

  • Chris Travers
    Chris Travers
    2008-08-16

    Logged In: YES
    user_id=80610
    Originator: NO

    I don't think this is a bug in the software. For now, try:

    SELECT setval('partsvendor_entry_id_seq', (select max(entry_id) from partsvendor));

    Then try again.

     
  • Chris Travers
    Chris Travers
    2008-08-16

    • assigned_to: nobody --> einhverfr
     
  • Chris Travers
    Chris Travers
    2011-06-24

    • status: open --> closed