Обсуждение: Inquiry From Form [pgsql]

Поиск
Список
Период
Сортировка

Inquiry From Form [pgsql]

От
Richard Lukacik
Дата:
Hi,
I have one problem.When I have defined trigger before update on some table, then update was succesfully performed but
updatedvalue haven\'t changed, his value is old!This effect has been althrough trigger function do not perform any
operation.If I drop trigger before update, then update was performed OK! Why? Where is the problem? 
Help. Thanks


Re: Inquiry From Form [pgsql]

От
Stephan Szabo
Дата:
On Thu, 28 Nov 2002, Richard Lukacik wrote:

> I have one problem.When I have defined trigger before update on some
> table, then update was succesfully performed but updated value
> haven\'t changed, his value is old!This effect has been althrough
> trigger function do not perform any operation. If I drop trigger
> before update, then update was performed OK! Why? Where is the
> problem?

You haven't sent the trigger, so it's hard to say, but I'd guess that
you might be returning either OLD or NULL from the trigger.