Postgres Pro
Downloads
Home   >   mailing lists

Re: NOT DEFERRABLE as default, why and how to manage it. - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: NOT DEFERRABLE as default, why and how to manage it.
Date
Msg-id 200808191120.09312.peter_e@gmx.net
Whole thread Raw
In response to NOT DEFERRABLE as default, why and how to manage it.  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: NOT DEFERRABLE as default, why and how to manage it.  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
Am Tuesday, 19. August 2008 schrieb Ivan Sergio Borgonovo:
> I just learnt that NOT DEFERRABLE is default.

> Is it mandated by SQL standard?

Yes.

> Is there any shortcut if I've to change to deferrable most of my
> constraints?

Probably not, short of writing a little script.

> Other than pgfoundry is there any other recipe repository where to
> look for refactoring tools for postgresql?

The wiki, I'd say.

pgsql-general by date:

Previous
From: tuanhoanganh
Date:
Subject: Pg dump Error
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: NOT DEFERRABLE as default, why and how to manage it.