No table marked for replication can have a selective update trigger on it. (A selective update trigger is an update trigger that references specific columns.)
In the Informix Dynamic Server, a table may have multiple update triggers, each of which specifies a subset of the columns. However, each column may be referenced by only one update trigger.
Replication Agent requires an update trigger for all columns (an entire row), so if a selective update trigger already exists on the table, Replication Agent cannot create its update trigger, and therefore it cannot replicate transactions against that table.
Dynamic Server 2000 allows users to create select triggers.
If the select trigger does not modify data in
the triggering table, then the selective select trigger
is allowed on marked tables.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
