Add `Close()` method to the connector for a pooled connection about pgx HOT 3 CLOSED

Closing the sql.DB shouldn't close the underlying pgxpool.Pool. It's entirely possible to create a pgxpool.Pool, use it to create sql.DB, close the sql.DB, and keep using the pgxpool.Pool.

from pgx.

@jackc
With that you are suggesting that users use both sql.DB and pgxpool.Pool for DB operations?
In the docs you specifically have a section that describes how to pick between the two when opening a new connection.
My assumption is that users that choose one don't also use the other, if that is a real use case, then I will close this issue.

from pgx.

Using both together is the use case. Sometimes someone will want to use pgx directly but also use a database/sql library like gorm.

from pgx.