I've been using PostgreSQL for about three months. So far my only objection is that "pg_affected" provides the number of attempts rather than the number of rows that are actually changed. I could easily do that with a little counter.
I think PostgreSQL should be changed to return the number of rows actually changed (whether updated, inserted or deleted).