Fixes for psycopg/psycopg

Verified fixes and incident notes extracted from GitHub Issues for psycopg/psycopg.