Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

Cannot update primary key for table '%1' involved in a publication

Error constant SQLE_ARTICLE_PK_CANNOT_BE_UPDATED
ODBC 2 State 42000
ODBC 3 State 42S02
Parameter 1 Name of the table.
Severity 16
SQLCODE –780
SQLSTATE 5RW19
Sybase error code 13790
Probable cause

The primary key of a table involved in a publication cannot be updated. The database option prevent_article_pkey_update can be set to 'off' to allow updates to the primary key of the table involved in the publication.