Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore option --clean - Mailing list pgsql-admin

From Fabrice Chapuis
Subject Re: pg_restore option --clean
Date
Msg-id CAA5-nLAvRTdqdpX_M=oWUxdUDcAUKa-PrCS-pbhAeP9KJ5XmKA@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore option --clean  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: pg_restore option --clean
List pgsql-admin
Tree view
But it does not work for the structure
# CONSTRAINT test FOREIGN KEY (id_tab_key) REFERENCES tab(id) ON DELETE cascade ON UPDATE CASCADE

ERROR:  cannot drop table tab because other objects depend on it

Regards,

Fabrice

On Wed, Feb 21, 2024 at 12:47 PM M Sarwar <sarwarmd02@outlook.com> wrote:
Look around for

ALTER TABLE TABLE-NAME
  ADD constraint fk-name foreign key col-name refers to tab-name ( col-name )
     on UPDATE cascase
   on DELETE CASCADE
;
Good luck,
Sarwar

From: Fabrice Chapuis <fabrice636861@gmail.com>
Sent: Wednesday, February 21, 2024 4:17 AM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Fwd: pg_restore option --clean
 


Hi,
The --clean option of pg_restore allows you to replace an object before being imported. However, dependencies such as foreign keys or views prevent the deletion of the object. Is there a way to add the cascade option to force the deletion?
Thanks for helping
Fabrice

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Re: pg_restore option --clean
Next
From: Guillaume Lelarge
Date:
Subject: Re: pg_restore option --clean