implementation of Executor is not general enough when use query_as

[Matrix-Zhang]

use sqlx::{FromRow, Executor, Postgres, postgres::PgRow};
use sqlx::postgres::PgPool; // Assuming you're using a PgPool for execution
use sqlx::Error; // For handling errors in a real application

#[derive(sqlx::FromRow)]
struct RowWithCount<T> {
    #[sqlx(flatten)]
    entity: T,
    count: i64,
}

pub trait EntityEx: for<'r> FromRow<'r, PgRow> + Sized {
    async fn loadex<'c, E>(executor: E) -> Result<(Vec<Self>, i64), Error>
    where
        E: Executor<'c, Database = Postgres>,
    {
        let results: Vec<RowWithCount<Self>> = sqlx::query_as(
            "SELECT *, COUNT(*) OVER () FROM fungible_asset ORDER BY created_at ASC LIMIT 10 OFFSET 0",
        )
        .fetch_all(executor)
        .await?;

        let count = results.first().map(|record| record.count).unwrap_or(0);
        Ok((
            results.into_iter().map(|record| record.entity).collect(),
            count,
        ))
    }
}

when i try to pass &PgPool to the executor, it errors

error: implementation of Executor is not general enough
--> src/startup.rs:110:38
|
110 | .route("/public/assets", get(public_assets))
| ^^^^^^^^^^^^^^^^^^ implementation of Executor is not general enough
|
= note: &sqlx::Pool<Postgres> must implement Executor<'0>, for any lifetime '0...
= note: ...but &sqlx::Pool<Postgres> actually implements Executor<'1>, for some specific lifetime '1