Re: Fwd: [NOVICE] Trigger and Recursive Relation ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nikolay(at)samokhvalov(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Fwd: [NOVICE] Trigger and Recursive Relation ?
Date: 2006-08-02 04:10:41
Message-ID: 5818.1154491841@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

"Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message tomas 2006-08-02 05:01:44 Re: pg_restore not work on windows 2000, when dump file size > 4G
Previous Message Jan Cruz 2006-08-02 01:36:00 BUGS: pg_restore custom archiver out of memory

Browse pgsql-novice by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-08-02 07:37:03 Re: Fwd: [NOVICE] Trigger and Recursive Relation ?
Previous Message frazelle09 2006-08-02 03:45:22 Re: Is there a gui front end for this wonderful db program