editing functions/triggers etc..

From: john <jfabiani(at)yolo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: editing functions/triggers etc..
Date: 2008-05-24 15:03:31
Message-ID: 200805240803.31468.jfabiani@yolo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioannis Tambouras 2008-05-24 15:06:40 Re: sequences and dependences
Previous Message Thomas Kellerer 2008-05-24 14:58:18 Re: XML2 module and xpath_table