Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: [NOVICE] Trigger and Recursive Relation ? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Fwd: [NOVICE] Trigger and Recursive Relation ?
Date
Msg-id 5818.1154491841@sss.pgh.pa.us
Whole thread Raw
In response to Fwd: [NOVICE] Trigger and Recursive Relation ?  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Responses Re: Fwd: [NOVICE] Trigger and Recursive Relation ?
List pgsql-bugs
Tree view 
"Nikolay Samokhvalov" <samokhvalov@gmail.com> writes:
> Is this a bug or not?

I don't think so --- or perhaps better, this is a buggy trigger.
he UPDATE in the trigger will supersede the base DELETE query for any
rows that the UPDATE changes before the base DELETE has reached 'em.
Essentially you've written an indeterminate system ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Jan Cruz"
Date:
Subject: BUGS: pg_restore custom archiver out of memory
Next
From: tomas@tuxteam.de
Date:
Subject: Re: pg_restore not work on windows 2000, when dump file size > 4G