pgcopy Release Notes

v0.6.0 – Safe streaming + predictable FK handling

Released: August 10, 2025

A compact stability release that makes streaming safe by default and simplifies foreign key handling without superuser rights.

Atomic streaming copies
- Destination TRUNCATE + COPY run in one transaction; failures roll back cleanly
- Prevents the “table ended up empty after streaming” class of issues
Predictable foreign keys (no superuser)
- Drops all incoming FKs referencing planned tables before copy; restores at the end
- Best‑effort FK restore on graceful shutdown (SIGINT/SIGTERM)
- Backup file kept while FKs are dropped; removed after successful restore
Safer truncation in parallel
- Removed TRUNCATE … CASCADE from all paths; rely on FK strategy/replica mode
- Broadened FK discovery to include constraints referencing planned tables

No breaking changes. Enable streaming via --copy-pipe (optionally --compress).
When superuser is available, replica mode is used and global FK drop is skipped.

08eb323: Add --no-timeouts flag to disable internal operation timeouts
6621420: Add optional progress polling for COPY operations in stream_copy
10129e4: Enhance foreign key management and transaction handling during table truncation and data copying
110eafe: Enhance foreign key management by implementing global drop and restore functionality during copy operations
64ebd28: Enhance progress bar styling with hover effects for improved readability and contrast
6426bfd: Enhance table row management with sorting and dynamic updates for copying status
3958e3b: Implement browser auto-opening based on copy status and add state observation method