Re: editing functions/triggers etc..

From: johnf <jfabiani(at)yolo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: editing functions/triggers etc..
Date: 2008-05-26 14:42:27
Message-ID: 200805260742.28055.jfabiani@yolo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-05-26 14:44:26 Re: Optimzing Postgresql
Previous Message Greg Smith 2008-05-26 12:29:19 Re: Performance Problem - pgsql on MD3000 DAS