Using PostGIS in sqlx::test

[nk9]

My database is created using Supabase. I'm managing migrations with their tools and not with sqlx. More about my setup in this previous question. Here's the code for my test:

#[cfg(test)]
mod tests {
    use super::*;

    #[sqlx::test(migrations = "../backend/supabase/migrations")]
    async fn test_assert(pool: PgPool) {
        assert_eq!(0, 1);
    }
}

My database also uses the PostGIS extension. In fact, it's the very first thing installed by my migration scripts:

../backend/supabase/migrations/20231216192815_initial_schema.sql

create schema if not exists "extensions";
create extension if not exists "postgis" with schema "extensions";

create table "public"."districts" (
    "id" integer generated by default as identity not null,
    "name" text not null,
    "metro_id" bigint,
    "census_year_id" bigint,
    "geom" geography(MultiPolygon,4326) not null
);

-- <snip>

The first two commands work when run by sqlx::test, but creating the table fails:

thread 'insert::tests::test_insert_years' panicked at /Users/nick/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-core-0.7.4/src/testing/mod.rs:248:14:
failed to apply migrations: Execute(Database(PgDatabaseError {
    severity: Error,
    code: "42704",
    message: "type \"geography\" does not exist",
    detail: None,
    hint: None,
    position: Some(Original(554)),
    where: None,
    schema: None,
    table: None,
    column: None,
    data_type: None,
    constraint: None,
    file: Some("parse_type.c"),
    line: Some(270),
    routine: Some("typenameType") }))

Is there some way to get this working? 🤞 This comment seems to say that adding extensions in migrations isn't supported, although the create extension command seems to work just fine above.