pg_restore option --clean

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: pg_restore option --clean
Date: 2024-02-20 07:47:52
Message-ID: CAA5-nLDfH=sHJvcudAUKn8eG=EoC4rtemr8Z9OZUrJKP_jsfcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message James Pang 2024-02-20 08:20:03 select statements have many shared_blks_dirtied and written
Previous Message Laurenz Albe 2024-02-20 07:42:46 Re: Wraparound

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2024-02-20 07:57:25 Re: automating RangeTblEntry node support
Previous Message Bharath Rupireddy 2024-02-20 07:45:00 Re: Switching XLog source from archive to streaming when primary available