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
