#13 Vendor Details Disappear When Parts Record Edited

closed
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
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks