Re: pg_restore option --clean

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(at)outlook(dot)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(at)gmail(dot)com>
> *Sent:* Wednesday, February 21, 2024 4:17 AM
> *To:* pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)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
>