Re: editing functions/triggers etc..

[Niklas Johansson <spot@xxxxxxxx>]

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