Skip to content

HINT: Use DROP ... CASCADE to also remove linked objects. Partitioning table causing error? #467

Open
@lidyum

Description

@lidyum

Is there a solution for this error?

I use architect 0.6.0 for table partitioning. betik_app_staff_workinghourmodel_y2022m05 table is a partition table.

Error: public.betik_app_staff_workinghourmodel_y2022m05 table depends on public.betik_app_staff_workinghourmodel table object

HINT: Use DROP ... CASCADE to also remove linked objects.

Traceback (most recent call last):
container@testserver    |   File "manage.py", line 22, in <module>
container@testserver    |     main()
container@testserver    |   File "manage.py", line 18, in main
container@testserver    |     execute_from_command_line(sys.argv)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
container@testserver    |     utility.execute()
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/django/core/management/__init__.py", line 413, in execute
container@testserver    |     self.fetch_command(subcommand).run_from_argv(self.argv)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/django/core/management/base.py", line 354, in run_from_argv
container@testserver    |     self.execute(*args, **cmd_options)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/django/core/management/base.py", line 398, in execute
container@testserver    |     output = self.handle(*args, **options)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/dbbackup/management/commands/dbrestore.py", line 68, in handle
container@testserver    |     self._restore_backup()
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/dbbackup/management/commands/dbrestore.py", line 118, in _restore_backup
container@testserver    |     self.connector.restore_dump(input_file)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/dbbackup/db/base.py", line 105, in restore_dump
container@testserver    |     return self._restore_dump(dump)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/dbbackup/db/postgresql.py", line 89, in _restore_dump
container@testserver    |     return super()._restore_dump(dump)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/dbbackup/db/postgresql.py", line 64, in _restore_dump
container@testserver    |     stdout, stderr = self.run_command(cmd, stdin=dump, env=self.restore_env)
container@testserver    |   File "/usr/local/lib/python3.8/site-packages/dbbackup/db/base.py", line 171, in run_command
container@testserver    |     raise exceptions.CommandConnectorError(
container@testserver    | dbbackup.db.exceptions.CommandConnectorError: Error running:  psql --dbname=postgresql://postgres_user:postgres_pass@db:5432/db --set ON_ERROR_STOP=on --single-transaction db
container@testserver    | ERROR:  Unable to remove table "public.betik_app_staff_workinghourmodel" because other objects depend on it
container@testserver    | DETAIL:  **public.betik_app_staff_workinghourmodel_y2022m05** table depends on **public.betik_app_staff_workinghourmodel** table object

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions