aws-sdk-pandas icon indicating copy to clipboard operation
aws-sdk-pandas copied to clipboard

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

Open senorcinco opened this issue 1 year ago • 1 comments

I've mostly used the SDK for loading data into Redshift, so I 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 avatar Mar 14 '24 13:03 senorcinco

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

kukushking avatar May 14 '24 10:05 kukushking