> database in my script. Is there a way to tell the server to abort the > COPY?
Try bumping the logging level and see if your script is issuing a PQcancel or not. It may or may not be, depending on how rudely things got interrupted. Also keep in mind that long-running COPYs can take a while to "unwind". If you are just looking for a way to cancel a still-running COPY, check the output of pg_stat_activity and confirm it is running (and grab the PID), and then send it a pg_cancel_backend(PID). -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
