SQL Interruption

With Informix®, it is possible to interrupt a long running query if the SQL INTERRUPT ON option.

PostgreSQL supports SQL Interruption in a similar way. The db client must issue an PQcancel() libPQ call to interrupt a query.

Solution

The PostgreSQL database driver supports SQL interruption and converts the SQLSTATE code 57014 to the Informix error code -213.