Implemented `pg_wait_notify` - uses `select` internally to wait for incoming notifications on the connection. They can then be retrieved with `pg_get_notify`.