PgAdvisoryLock missing necessary AsMut<PgConnection>

[conradludgate]

Bug Description

https://docs.rs/sqlx/0.6.3/sqlx/postgres/struct.PgAdvisoryLock.html#method.acquire

A connection-like type is required to execute the call. Allowed types include PgConnection, PoolConnection and Transaction, as well as mutable references to any of these.

Neither Transaction<Postgres> nor PgConnection implement the required AsMut<PgConnection> trait.

Minimal Reproduction

pub fn demo<'l>(
    lock1: PgAdvisoryLockGuard<'l, PgConnection>,
    lock2: PgAdvisoryLockGuard<'l, Transaction<Postgres>>,
) {
}

error[E0277]: the trait bound `PgConnection: AsMut<PgConnection>` is not satisfied
   --> src/repositories/deposit/queries.rs:640:12
    |
640 |     lock1: PgAdvisoryLockGuard<'l, PgConnection>,
    |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ the trait `AsMut<PgConnection>` is not implemented for `PgConnection`
    |
note: required by a bound in `PgAdvisoryLockGuard`
   --> /Users/conrad.ludgate/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-core-0.6.3/src/postgres/advisory_lock.rs:80:42
    |
80  | pub struct PgAdvisoryLockGuard<'lock, C: AsMut<PgConnection>> {
    |                                          ^^^^^^^^^^^^^^^^^^^ required by this bound in `PgAdvisoryLockGuard`

error[E0277]: the trait bound `Transaction<'_, Postgres>: AsMut<PgConnection>` is not satisfied
   --> src/repositories/deposit/queries.rs:641:12
    |
641 |     lock2: PgAdvisoryLockGuard<'l, Transaction<Postgres>>,
    |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ the trait `AsMut<PgConnection>` is not implemented for `Transaction<'_, Postgres>`
    |
note: required by a bound in `PgAdvisoryLockGuard`
   --> /Users/conrad.ludgate/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-core-0.6.3/src/postgres/advisory_lock.rs:80:42
    |
80  | pub struct PgAdvisoryLockGuard<'lock, C: AsMut<PgConnection>> {
    |                                          ^^^^^^^^^^^^^^^^^^^ required by this bound in `PgAdvisoryLockGuard`

Info

• SQLx version: 0.6.3
• SQLx features enabled:
  • "chrono",
  • "offline",
  • "postgres",
  • "runtime-tokio-native-tls",
  • "macros",
  • "migrate",
  • "uuid",
  • "json",
  • "bigdecimal",
• Database server and version: Postgres
• Operating system: MacOS
• rustc --version: 1.69.0

[abonander]

Closed by #2554