Modifying a primary key on er

Hi, I need to alter a primary key of a table that is on an enterprise replication, so I used the next command: cdr alter --on db:owner.table And it works well, then I use the alter command and it works great, the table was altered. After that I execute the next command; cdr alter --off db:owner.table To avoid the table be altered in the future. But it doesn't work I still can alter the table without problems. What can I do ? Enviado desde mi iPhone

Hi, You didn't specify ids version and type of change of pk you are doing, but as per the documentation: Alter mode is a state in which only DDL and SELECT operations are allowed but DML operations are not allowed. And if either of the following conditions are true,then alters on the pk should work fine with no special requirements: 1. The table uses ERKEY shadow columns or another unique index or constraint as the replication key 2. The primary key contains multiple columns. The column modification implicitly re-creates the primary key. Regards, Lyubomir On Aug 4, 2015 10:56 PM, "Jorge Valenzuela" <jorgervt@gmail.com> wrote: > Hi, > I need to alter a primary key of a table that is on an enterprise > replication, > so I used the next command: > cdr alter --on db:owner.table > And it works well, then I use the alter command and it works great, the > table > was altered. > After that I execute the next command; > cdr alter --off db:owner.table > To avoid the table be altered in the future. > But it doesn't work I still can alter the table without problems. What can > I > do ? > > Enviado desde mi iPhone > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013a13bc432192051c82ad4c