SQL adaptation guide for PostgreSQL 9.x / BDL programming |
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.
The PostgreSQL database driver supports SQL interruption and converts the SQLSTATE code 57014 to the Informix error code -213.