[PostgreSQL] Error migrate:rollback

[caosdp-rs]

Postgresql 11

PS C:\laragon\www\creditos> php spark migrate:rollback

CodeIgniter v4.2.1 Command Line Tool - Server Time: 2022-07-29 18:07:49 UTC-03:00

Revertendo todas as migrações... 0

[ErrorException]

pg_query(): Query failed: ERROR: cannot drop table users because other objects depend on it DETAIL: constraint auth_identities_user_id_foreign on table auth_identities depends on table users constraint auth_remember_tokens_user_id_foreign on table auth_remember_tokens depends on table users constraint auth_groups_users_user_id_foreign on table auth_groups_users depends on table users constraint auth_permissions_users_user_id_foreign on table auth_permissions_users depends on table users HINT: Use DROP ... CASCADE to drop the dependent objects too.

at SYSTEMPATH\Database\Postgre\Connection.php:135

Backtrace: 1 [internal function] CodeIgniter\Debug\Exceptions()->errorHandler(2, 'pg_query(): Query failed: ERROR: cannot drop table users because other objects depend on it DETAIL: constraint auth_identities_user_id_foreign on table auth_identities depends on table users constraint auth_remember_tokens_user_id_foreign on table auth_remember_tokens depends on table users constraint auth_groups_users_user_id_foreign on table auth_groups_users depends on table users constraint auth_permissions_users_user_id_foreign on table auth_permissions_users depends on table users HINT: Use DROP ... CASCADE to drop the dependent objects too.', 'C:\laragon\www\creditos\vendor\codeigniter4\framework\system\Database\Postgre\Connection.php', 135, [...])

2 SYSTEMPATH\Database\Postgre\Connection.php:135 pg_query(NULL, 'DROP TABLE IF EXISTS "users"')

3 SYSTEMPATH\Database\BaseConnection.php:695 CodeIgniter\Database\Postgre\Connection()->execute('DROP TABLE IF EXISTS "users"')

4 SYSTEMPATH\Database\BaseConnection.php:609 CodeIgniter\Database\BaseConnection()->simpleQuery('DROP TABLE IF EXISTS "users"')

5 SYSTEMPATH\Database\Forge.php:614 CodeIgniter\Database\BaseConnection()->query('DROP TABLE IF EXISTS "users"')

6 VENDORPATH\codeigniter4\shield\src\Database\Migrations\2020-12-28-223112_create_auth_tables.php:139 CodeIgniter\Database\Forge()->dropTable('users', true)

7 SYSTEMPATH\Database\MigrationRunner.php:868 CodeIgniter\Shield\Database\Migrations\CreateAuthTables()->down()

8 SYSTEMPATH\Database\MigrationRunner.php:298 CodeIgniter\Database\MigrationRunner()->migrate('down', Object(stdClass))

9 SYSTEMPATH\Commands\Database\MigrateRollback.php:92 CodeIgniter\Database\MigrationRunner()->regress(0)

10 SYSTEMPATH\CLI\Commands.php:63 CodeIgniter\Commands\Database\MigrateRollback()->run([])

11 SYSTEMPATH\CLI\CommandRunner.php:65 CodeIgniter\CLI\Commands()->run('migrate:rollback', [])

12 SYSTEMPATH\CLI\CommandRunner.php:51 CodeIgniter\CLI\CommandRunner()->index([])

13 SYSTEMPATH\CodeIgniter.php:889 CodeIgniter\CLI\CommandRunner()->_remap('index', [...])

14 SYSTEMPATH\CodeIgniter.php:466 CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

15 SYSTEMPATH\CodeIgniter.php:345 CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

16 SYSTEMPATH\CLI\Console.php:48 CodeIgniter\CodeIgniter()->run()

17 ROOTPATH\spark:86 CodeIgniter\CLI\Console()->run()

[caosdp-rs]

change position $this->forge->dropTable('users', true); to last line

[kenjis]

Thank you for reporting.

It seems you are the first person who uses PostgreSQL with Shield. PRs are welcome! See https://github.com/codeigniter4/CodeIgniter4/blob/develop/contributing/README.md

[kenjis]

DEFERRABLE NOT DEFERRABLE

This controls whether the constraint can be deferred. A constraint that is not deferrable will be checked immediately after every command. Checking of constraints that are deferrable can be postponed until the end of the transaction (using the SET CONSTRAINTS command). NOT DEFERRABLE is the default. Currently, only UNIQUE, PRIMARY KEY, EXCLUDE, and REFERENCES (foreign key) constraints accept this clause. NOT NULL and CHECK constraints are not deferrable. Note that deferrable constraints cannot be used as conflict arbitrators in an INSERT statement that includes an ON CONFLICT DO UPDATE clause. https://www.postgresql.org/docs/14/sql-createtable.html