migration:fresh problem. Bug when using postgres with schemas (other than public)?

[rbartholomay]

Hi there!

I use adonis ("@adonisjs/lucid": "^18.3.0") with a postgres database and i have this config:

    pg: {
      client: 'pg',
      connection: {
        host: Env.get('PG_HOST'),
        port: Env.get('PG_PORT'),
        user: Env.get('PG_USER'),
        password: Env.get('PG_PASSWORD', ''),
        database: Env.get('PG_DB_NAME'),
        //ssl: {
        //  rejectUnauthorized: false,
        //},
      },
      migrations: {
        naturalSort: true,
      },
      healthCheck: true,
      debug: Env.get('PG_DEBUG'),
      searchPath: Env.get('PG_DB_SCHEMA').split(',') || ['PUBLIC'],
    },

inside the .env file the PG_DB_SCHEMA ist set to:

PG_DB_SCHEMA=my-special-schema

All runs fine (migrations etc.) except when using the command migrate:fresh
When using this command lucid try do wipe tables in the public schema not in my-special-schema

[11:33:40.484] INFO (sparrow/48520): Scheduler is running...
"pg" (7.66 ms) SELECT "tablename" AS "table_name" FROM "pg_catalog"."pg_tables" WHERE "schemaname" IN (?) ORDER BY "tablename" ASC [ 'public' ]
[ success ]  Dropped tables successfully
"pg" (1.4 ms) SELECT PG_TRY_ADVISORY_LOCK('1') AS lock_status; []
"pg" (1.62 ms) SELECT "version" FROM "adonis_schema_versions" LIMIT ? [ 1 ]
"pg" (2.52 ms) SELECT MAX("batch") AS "batch" FROM "adonis_schema" []
"pg" (999 μs) SELECT "name" FROM "adonis_schema" []
"pg" (1.27 ms) SELECT PG_ADVISORY_UNLOCK('1') AS lock_status; []

Miss i something or is this a bug? The SQL-Statement use Public instead of my-special-schema: ... ASC [ 'public' ]

Bye René

[rbartholomay]

after looking in the sources it must be a bug... I add an issue for this: Issue 926