Re: editing functions/triggers etc..

From: Niklas Johansson <spot(at)tele2(dot)se>
To: john <jfabiani(at)yolo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: editing functions/triggers etc..
Date: 2008-05-26 09:17:59
Message-ID: C370C3F1-0EE1-4AA2-8310-F186C3E952D5@tele2.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomasz Ostrowski 2008-05-26 11:24:58 Re: Performance Problem - pgsql on MD3000 DAS
Previous Message Kless 2008-05-26 08:38:49 Money data type - Deprecated?