Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Why doesn't postgresql.to_sql support a TRUNCATE overwrite_method? #2728

Closed
senorcinco opened this issue Mar 14, 2024 · 1 comment · Fixed by #2820
Closed

Why doesn't postgresql.to_sql support a TRUNCATE overwrite_method? #2728

senorcinco opened this issue Mar 14, 2024 · 1 comment · Fixed by #2820
Assignees
Labels
backlog enhancement New feature or request question Further information is requested

Comments

@senorcinco
Copy link

senorcinco commented Mar 14, 2024

I've mostly used the SDK for loading data into Redshift, so I was surprised to learn that postgresql.to_sql doesn't support a TRUNCATE overwrite_method. I need to preserve table indexes, so dropping the table isn't possible. I read that a PostgreSQL TRUNCATE isn't MVCC compliant. Is that the reason why it isn't supported?

@senorcinco senorcinco added the question Further information is requested label Mar 14, 2024
@kukushking
Copy link
Contributor

Thanks @senorcinco no I think it's just an oversight. We'll add it to our backlog.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backlog enhancement New feature or request question Further information is requested
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants