Add cancel/1 API to pgsql

Add capability to cancel existing connection by exposing
pgsql_connection's internal cancel interface at the next higher level;