Re: Inquiry From Form [pgsql] - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Inquiry From Form [pgsql]
Date
Msg-id 20021128101525.I7870-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Inquiry From Form [pgsql]  (Richard Lukacik <richard.lukacik@frequentis.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Firing Orders
Next
From: Neil Conway
Date:
Subject: Re: Why does everyone think MySQL is easier?