| Lists: | pgsql-bugs |
|---|
| From: | "Sebastien MAYER" <sebastien(dot)mayer(at)briosoft(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2464: 'After' are not called the first time of the user session |
| Date: | 2006-06-02 16:11:48 |
| Message-ID: | 200606021611.k52GBmjJ048042@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2464
Logged by: Sebastien MAYER
Email address: sebastien(dot)mayer(at)briosoft(dot)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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sebastien MAYER" <sebastien(dot)mayer(at)briosoft(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2464: 'After' are not called the first time of the user session |
| Date: | 2006-06-03 15:01:35 |
| Message-ID: | 15902.1149346895@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Sebastien MAYER" <sebastien(dot)mayer(at)briosoft(dot)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