BEFORE UPDATE trigger doesn't change column value

Поиск
Список
Период
Сортировка
От Clemens Eisserer
Тема BEFORE UPDATE trigger doesn't change column value
Дата
Msg-id CAFvQSYT3AOi7FT3XkhGP7PsJRpJNgTv6i=zMxxcmXUFMxxqLBw@mail.gmail.com
обсуждение исходный текст
Ответы Re: BEFORE UPDATE trigger doesn't change column value
Re: BEFORE UPDATE trigger doesn't change column value
Список pgsql-general
Hi,

Sorry for this newbie-question, I am trying for quite some time now to get the following trigger-function to work properly:

CREATE OR REPLACE FUNCTION update_synced_column()
  RETURNS trigger AS
$BODY$
BEGIN
   IF NEW.synced IS NULL THEN
    NEW.synced :=  false;
   END IF;
   RETURN NEW;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

The idea is basically to always update the "synced" column to false, unless a value has been provided manually in the UPDATE-clause.
Synced is defined as BOOLEAN DEFAULT FALSE;
I execute this function in a BEFORE UPDATE trigger FOR EACH ROW, however it doesn't seem to have any effect.

Any ideas what could be wrong here?

Thanks, Clemens

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug or feature? (The constraint of the domain of extension can be dropped...)
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: BEFORE UPDATE trigger doesn't change column value