Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    33

    Unanswered: Duplicate rows although there is a serial column.

    Hi,

    we are running Informix Dynamic Server 9.30 and today I saw the first time that in a table with a serial column there were 3 identically rows (the serial column too). Before today I thought this could not happen.

    Any ideas (reasons or how to prevent it) ?

    Thanks for help.

  2. #2
    Join Date
    Jan 2005
    Posts
    30

    Lightbulb

    You can create a unique index or a primary key constraint on the serial column.

    __
    SC

  3. #3
    Join Date
    Mar 2005
    Location
    Bs. As. - Argentina
    Posts
    2
    Do you load data into the table? This could be the reason.

Posting Permissions

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