Logical replication, need to get only the changed column values, not all column values, on update event row
Open
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 8.7k
- Forks
- 374
- Avg merge
- 11d 16h
- Merged PRs (30d)
- 1
Description
Hello.
When an update event occurs, all columns are sent to the subscription handler, even those that were not updated. In my business logic, I need to understand which columns have changed their values. How can this be done?
Thanks.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file or test is named. Start by tracing the logical replication update event into the subscription handler and reviewing how PostgreSQL represents changed columns. Done should mean establishing whether the handler can receive only changed values, or documenting the limitation and the supported way to identify them.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, nodejs, postgresql
- Domain
- backend, databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100