Re: [GENERAL] editing functions/triggers etc..

On Monday 26 May 2008 02:17:59 am Niklas Johansson wrote:
> On 24 maj 2008, at 17.03, john wrote:
> > I was wondering if anyone has written a tool that will drop
> > (cascade) then
> > allow the edit and then restore the functions/triggers including
> > the adding
> > the function/triggers to the inserts/deletes/etc.. to the tables.
>
> Just use
>
> CREATE OR REPLACE your_trigger_function() RETURNS TRIGGER AS ...
>
> to replace the trigger function in place.
>
>
>
> Sincerely,
>
> Niklas Johansson

I'm away at the moment but that thanks it looks to be the solution. Do I feel
dumb!

--
John Fabiani

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general