From: | "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Fwd: [NOVICE] Trigger and Recursive Relation ? |
Date: | 2006-08-02 21:06:38 |
Message-ID: | e431ff4c0608021406n2514b28ctcb9a3abffec0d3c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-novice |
On 8/2/06, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> wrote:
> Does Postgres work this way? In the case of 'delete from tbl;' we
> have search condition>=TRUE for all rows. If we evaluate it *before*
> any other operation, we should mark all rows to be deleted. I guess,
> Postgres doesn't follow this logic..
My assumption: Postgres takes one row, marks it as deleted, then
executes trigger and updates another row. Due to MVCC new version of
that row is created and in the following iteration Postgres simply
doesn't "see" this row...
I don't understand how this can be called "not bug"... Please, help me
understand it :-)
--
Best regards,
Nikolay
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-08-02 21:47:24 | Re: Fwd: [NOVICE] Trigger and Recursive Relation ? |
Previous Message | Ralf S. Engelschall | 2006-08-02 19:04:11 | Patch to allow C extension modules to initialize/finish |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-08-02 21:47:24 | Re: Fwd: [NOVICE] Trigger and Recursive Relation ? |
Previous Message | Nikolay Samokhvalov | 2006-08-02 07:37:03 | Re: Fwd: [NOVICE] Trigger and Recursive Relation ? |