Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    60

    Unanswered: Informix Replication

    G'd day

    Does anyone know if there is a way to use Enterprise Replication with a database when we have a few tables that do not have a primary key ?

    Cheers,

    Philippe

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    There is no way to do this.

    You always need a primary key on a table when you
    want to define a replicate on it, regardless if you
    setup an update anywhere or a master-slave replication.

    Also be careful if you currently have a unique index and
    want to 'upgrade' this to a primary key in order to use
    ER.
    Your application might fail, because they receive different
    error message during an insert of a duplicate key
    in this table.

    - table with unique index
    -> -239 'could not insert new row - duplicate value....'

    - table with primary key constraint
    -> -268 'unique constraint violated'

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Feb 2003
    Posts
    60
    That's what I thought.
    I was told that with Oracle, you could actually 'define' a primary key while setting up replication. That means that you can choose a set of columns, and 'define' them as a 'replication primary key'.
    I thought maybe that could exist in Informix to.

    Thanks for your help Eric.

Posting Permissions

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