db:fresh and db:wipe commands fail with PostGIS extension

[brkn]

Package version

"@adonisjs/lucid": "^17.1.1",
"@adonisjs/core": "^5.6.2",
"@adonisjs/assembler": "^5.4.2",

"pg": "^8.7.3",

"knex-postgis": "^0.14.3",

Node.js and npm version

v16.1.0
7.11.2

Sample Code (to reproduce the issue)

1. Add postGIS extension

CREATE extension if not exists postgis;

2. Run node ace migration:fresh

❯ node ace migration:fresh

error: DROP table adonis_schema,adonis_schema_versions,api_tokens,app_configs,users CASCADE; -
cannot drop table spatial_ref_sys because extension postgis requires it


1 Parser.parseErrorMessage
  /node_modules/pg-protocol/src/parser.ts:369

2 Parser.handlePacket
  /node_modules/pg-protocol/src/parser.ts:188

3 Parser.parse
  /node_modules/pg-protocol/src/parser.ts:103

4 anonymous
  /node_modules/pg-protocol/src/index.ts:7

[brkn]

Rails have ignore_tables to solve this issue I think. A similar solution can be implemented maybe.

[0] https://stackoverflow.com/questions/40882420/rails-postgis-error-cannot-drop-table-spatial-ref-sys

[thetutlage]

Thanks for reporting. I will do some reading on this 👍

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[thetutlage]

@Julien-R44 Any plans to tackling this issue?