Postgres Pro
Downloads
Home   >   mailing lists

Re: editing functions/triggers etc.. - Mailing list pgsql-general

From Niklas Johansson
Subject Re: editing functions/triggers etc..
Date
Msg-id C370C3F1-0EE1-4AA2-8310-F186C3E952D5@tele2.se
Whole thread Raw
In response to editing functions/triggers etc..  (john <jfabiani@yolo.com>)
Responses Re: editing functions/triggers etc..  (johnf <jfabiani@yolo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Rob Wultsch"
Date:
Subject: Re: Optimzing Postgresql
Next
From: Tomasz Ostrowski
Date:
Subject: Re: Performance Problem - pgsql on MD3000 DAS