Changing a trigger function

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Changing a trigger function
Date: 2008-04-24 09:08:12
Message-ID: 608b66ce0804240208k245fab0bpd4f9de06d40b6fcb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have found a nasty bug in one of the trigger function I did put into
production a couple of days ago. I have a fix for it but wonder if I
can put it into the production database with users connected on it.

What would happen if someone sends an update firing that trigger
whilst I am in the middle of updating it via a create or update ? Do
I need to wait for this evening or can I safely runs the update of the
function ?

I know that several other databases would reject the update (Sybase,
Firebird for example) but I am too new to PostgresSQL to know what
would happen in such a situation

Didier

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Didier Gasser-Morlay 2008-04-24 09:12:47 Re: Client connection lost; still in the task list
Previous Message Didier Gasser-Morlay 2008-04-24 08:21:55 Re: restoring with pg_restore