Re: How can I set all constraints to be deferrable for a DB/schema

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: David Gauthier <davegauthierpg(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How can I set all constraints to be deferrable for a DB/schema
Date: 2020-03-18 10:31:43
Message-ID: CAECtzeUpcV3AizZLMwv1PTMmfUZt__u=wiZkZ1AFN_8nzQ59gA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Le mer. 18 mars 2020 à 04:14, David Gauthier <davegauthierpg(at)gmail(dot)com> a
écrit :

> Hi:
>
> psql (9.6.7, server 11.3) (linux)
>
> Is there a way to set all constraints on all tables of a DB and/or schema
> to be deferrable ? Or do I have to do them one-by-one ?
>
>
You have to do them one by one. Or write a DO script to do it (but it will
still involve many ALTER TABLE statements).

--
Guillaume.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stan 2020-03-18 10:47:52 propogate RAISE levels < EXCEPTION through MS Access?
Previous Message Daniel Westermann (DWE) 2020-03-18 07:17:16 Re: Temporary tablespaces on a RAM disk