editing functions/triggers etc..
Hi,
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.
It turns out that have to change 50 fifty triggers. At the moment I create a
list of the tables -remove the link, edit the code, restore the link. This
is not working very well.
TIA
John
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
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