Re: pg_restore problem to load constraints with tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore problem to load constraints with tables
Date: 2024-02-20 15:58:50
Message-ID: 186809.1708444730@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fabrice Chapuis <fabrice636861(at)gmail(dot)com> writes:
> When a table is reloaded wit pg_restore, it is recreated without indexes or
> constraints. There are automatically skipped. Is there a reason for this?

[ shrug ] That's how the -t switch is defined. If you want something
else, you can use the -l and -L switches to pick out a custom
collection of objects to restore.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2024-02-20 16:03:53 Re: Fix race condition in InvalidatePossiblyObsoleteSlot()
Previous Message Bertrand Drouvot 2024-02-20 15:55:08 Re: Injection points: some tools to wait and wake