Re: "too clever" when creating SQL functions - Mailing list pgsql-sql

From Richard Huxton
Subject Re: "too clever" when creating SQL functions
Date
Msg-id 200305072010.49526.dev@archonet.com
Whole thread Raw
In response to "too clever" when creating SQL functions  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-sql
On Wednesday 07 May 2003 6:51 pm, SZŰCS Gábor wrote:
> Dear Gurus,
>
> Please show me to the archives, if you feel like. I have an ugly function
> that can't be defined as language SQL, because it gets parsed at
> define-time, not run-time. Any ideas, other than making it plpgsql?
>
> Even better, is there a more elegant way to turn off/on triggers on a (set
> of) table(s)?

You might want to look at the output of pg_dump - IIRC that disables all your
triggers (fk's etc) and re-enables them at the end. Might be what you're
after.
--  Richard Huxton



pgsql-sql by date:

Previous
From: mdc@keko.com.ar
Date:
Subject: help database corruption
Next
From: Stephan Szabo
Date:
Subject: Re: help database corruption