duckdb / duckdb/duckdb-postgres
Make the transaction snapshot ID an ATTACH parameter
- Dominant language
- C++
- Stars
- 372
- Forks
- 105
- Avg merge
- 10h 19m
- Merged PRs (30d)
- 18
Description
Hello !
I recently encountered a need where I wanted to `COPY` multiple tables within the same transaction snapshot ID.
As I understand it, duckdb already uses transaction snapshots to copy a single table in parallel.
The idea is to add another PostgreSQL specific option to the `ATTACH` command which would always use the given transaction snapshot when calling the function `PostgresScanConnect`.
This would allow duckdb to take consistent snapshots of Postgres databases, which I believe is quite useful.
What do you think about this feature ?
Thanks a lot for the amazing software !
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.