1回答
- 新しい順
- 投票が多い順
- コメントが多い順
2
Hi,
My understanding is that only changes can be propagated by DMS. Mostly because it uses the rdbms logs to capture those changes and those logs do not contain full rows but only delta.
Nonetheless, you can achieve what you want by using a sql trigger: https://www.postgresql.org/docs/current/sql-createtrigger.html
The idea is the following; the trigger with fire on any change on the row brought by a DMS change. Then this trigger selects in full (i.e. all columns as neeed) the row as change is applied. This trigger then "pushes" the full row whenever you need: write it in another table, steams it outside of pg, etc.
Hope it helps!
Didier
but apparently when using MySQL as source there is a configuration for this in the DMS it would be (ndb_log_updated_only = OFF), is there really nothing to be done in the DMS itself?