Adding a custom conflict-handling function v7
To add a custom conflict handling function to the primary definition node:
Add the publication under the primary definition node. See Adding a publication.
Add the function to the primary definition node. The following example shows adding the function using PSQL.
Open the Conflict Resolution Options tab. Select Publication > Update Publication > Conflict Resolution Options.
For the table on which you want to use custom conflict handling, select Custom from the corresponding list. In the Custom Handler text box, enter the schema and function name used in the
CREATE FUNCTION
statement.Select Update, and then select OK in response to confirmation message.
Note
If the multi-master replication system uses custom conflict handling and you later switch the role of the primary definition node to another primary node, you must add the functions to the new primary definition node.
Note
If you want to delete the multi-master replication system, before removing the publication, remove all custom conflict-handling functions from the primary definition node.
The following example shows deleting a custom conflict function.