Nikolay Grebnev wrote:
> Good Day,
>
> I recently posted a message here
> (http://archives.postgresql.org/pgsql-hackers/2007-12/msg00340.php)
> that the trigger does not work as it should from time to time. Now the
> trigger works on C, before It was on TCL and it had the same problem.
> As the trigger works all right in 99.999 % cases (or even more) then
> we can make a conclusion that the trigger is written all right. And it
> was written in complete accordance with the documentation that is
> possible to find.
> I suggest to write down in documentation for PostgreSQL, that during
> big loads triggers can fail in some cases.
>
>
I think you need to provide a reproducable, self-contained test case, if
possible.
Your previous mail said:
> In php where the queries are formed we see that the query is sent for
> execution and executed ant the base was modified, but the trigger
> seems just to skip it (does not work with the query).
It would be far better to check that the statement has executed in the
log, after turning on log_statement or log_min_duration_statement.
Does it fail in inserts, updates, deletes, or all three?
What platform are you using?
And why are you compiling with -O3?
cheers
andrew