duckdb / duckdb/duckdb-postgres

Make the transaction snapshot ID an ATTACH parameter

Open
#403 2 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.