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