wal2json
wal2json copied to clipboard
JSON output plugin for changeset extraction
fixes #106
Adding new parameter `skip-empty-xacts`. I chose the same parameter name as Postgres' `test_decoding`. This should resolve #106.
I am currently testing this against Debezium, will un-draft when I have verified the code builds.
Currently numeric values are output as-is, e.g. ```javascript { "action": "U", "schema": "public", "table": "type_test", "columns": [ { "name": "id", "value": 1 }, // ... { "name": "f_numeric", "value": 1012345000999912345001230123445566.00000000...
Updating a table with JSON columns will treat the row data as a standard string, adding erroneous double-quotes around the value, instead of returning as an array/object. Example result (from...
This is essentially the same issue as #221 but with hstore. The string returned as the value is double-quoted and contains all the original hstore double-quotes with no escaping. Example...
Hello We faced an issue today: ERROR: could not open relation with OID 149416084 From postgres log: 2021-11-03 01:22:19.505 UTC [31907] (user=xmcdcuser) (db=na5) (rhost=10.139.204.7) (app=auditConsumer) [vxid:843/0 txid:0] [idle] ERROR: could...
I've written some docs. I've actually only just looked into the TOASTed column stuff. I also noticed a missing parameter, which I added.
… that toasted data for those columns is missing I have added an option called include-missing-toast so that an additional data element will be added to the output which would...
Hey, Happy to provide a PR, just want to check it's wanted. I couldn't find any description of what "oldkeys" was. Now I traced the code, and my understanding is...