Re: pg_restore problem to load constraints with tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_restore problem to load constraints with tables
Date
Msg-id 186809.1708444730@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore problem to load constraints with tables  (Fabrice Chapuis <fabrice636861@gmail.com>)
List pgsql-hackers
Fabrice Chapuis <fabrice636861@gmail.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



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Injection points: some tools to wait and wake
Next
From: Bertrand Drouvot
Date:
Subject: Re: Fix race condition in InvalidatePossiblyObsoleteSlot()