Обсуждение: BUG #2464: 'After' are not called the first time of the user session

The following bug has been logged online:

Bug reference:      2464
Logged by:          Sebastien MAYER
Email address:      sebastien.mayer@briosoft.com
PostgreSQL version: 8.1.4-1.FC5
Operating system:   Fedora Core 5
Description:        'After' are not called the first time of the user
session
Details:

I use Trigger after create/modif/delete of records in a table.
In this Trigger, i call a function in a Clib i wrote to send an UDP datagram
to signal users of a table modification.
They update their screen without intervention.
I make function with success for some time.
The code in the function has been separately tested (it is so simple code
anyway..).
For each session, the first creat/modif/delete is not reported with the UDP
datagram.
Is it a known bug ?

seb

"Sebastien MAYER" <sebastien.mayer@briosoft.com> writes:
> I use Trigger after create/modif/delete of records in a table.
> In this Trigger, i call a function in a Clib i wrote to send an UDP datagram
> to signal users of a table modification.
> They update their screen without intervention.
> I make function with success for some time.
> The code in the function has been separately tested (it is so simple code
> anyway..).
> For each session, the first creat/modif/delete is not reported with the UDP
> datagram.
> Is it a known bug ?

I'll bet lunch it's a bug in your trigger code.  You really think we'd
not have noticed if there were a generic problem of this description?

            regards, tom lane