Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC

dbvrep> SET_CONFLICT_HANDLERS FOR DEFAULT FOR UPDATE ON DATA TO OVERWRITE

This sets the default conflict handler for updates to overwrite.

To show the default global conflict handlers use the SHOW_CONFLICT_HANDLERS command:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC

dbvrep> SHOW_CONFLICT_HANDLERS FOR DEFAULT
The default handling is set as follows:
UPDATE (error): handler: RETRY logging: LOG
UPDATE (data): handler: OVERWRITE logging: LOG
DELETE (error): handler: RETRY logging: LOG
DELETE (data): handler: RETRY logging: LOG
INSERT (error): handler: RETRY logging: LOG
TRANSACTION (error): handler: RETRY logging: LOG

This shows the default conflict handler for updates to overwrite.