On Tue, 19 Aug 2008 11:20:08 +0300
Peter Eisentraut <peter_e@gmx.net> wrote:
> 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 reason they put it that way in the standard other than
the mantra "stricter is better"?
> > Is there any shortcut if I've to change to deferrable most of my
> > constraints?
>
> Probably not, short of writing a little script.
Reading the wiki an alter constraint is in the TODO.
What about a:
update pg_constraint set deeferrable=true where contype='f' and
confupdtype<>'r' and confdeltype<>'r' ...
BTW looking at pg_constraint and
http://www.alberton.info/postgresql_meta_info.html
was inspirational.
What are the general rules about modifying the system tables?
Where can I find what can be done and when and what can't be done?
> > Other than pgfoundry is there any other recipe repository where
> > to look for refactoring tools for postgresql?
> The wiki, I'd say.
Thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it