subject:"How can I set all constraints to be deferrable for a DB\/schema"

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

2020-03-18 Thread Guillaume Lelarge

Hi, Le mer. 18 mars 2020 à 04:14, David Gauthier 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

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

2020-03-17 Thread David Gauthier

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 ?