Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    1

    Unanswered: Help analyze error messages

    This is from a Pers script using PG module and interacting with database. What could this mean?



    Thu Aug 31 11:49:37 2006: Query failed: ERROR: Cannot insert a duplicate key into unique index savegrouprun_pkey

    Thu Aug 31 11:49:37 2006: ERROR: AddSaveGroupRun(27, Aug 31 12:00:00 2006, Aug 31 12:00:04 2006, 1) Failed!
    Thu Aug 31 11:49:37 2006: Trying Again...


  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    It looks like you're trying to violate the primary or unique key contstraint for your table.

    Since the name of the constraint is savegrouprun_pkey, it's probably the primary key.

    It also appears that the insertion id coming from a stored function called AddSaveGroupRun

    Note:
    Code:
    select	a.constraint_name, b.table_name, b.column_name
    from	information_schema.table_constraints a, information_schema.key_column_usage b
    where	a.constraint_name = b.Constraint_name and
    	a.constraint_name = 'savegrouprun_pkey'
    order by  b.ordinal_position
    will tell you which table/columns define the primary key constraint.
    Last edited by loquin; 08-31-06 at 18:22.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •