Re: NOT DEFERRABLE as default, why and how to manage it.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Subject: Re: NOT DEFERRABLE as default, why and how to manage it.
Date: 2008-08-19 08:20:08
Message-ID: 200808191120.09312.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-08-19 08:49:11 Re: NOT DEFERRABLE as default, why and how to manage it.
Previous Message tuanhoanganh 2008-08-19 08:09:31 Pg dump Error