From: | Marcus Mascari <mascarim(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Cascading Updates |
Date: | 1999-01-29 10:35:09 |
Message-ID: | 19990129103509.11737.rocketmail@send105.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Well,
I attempted to modify refint.c myself to support
cascading updates, but I'm seeing a weird affect.
The cascing update works, except only on the first
execution of the update. Each additional update
doesn't cause any change to the related tables.
If, however, I close the client, say, psql, and
then perform another update, the trigger fires and
the cascading update is performed.
All I changed in the code was to perform an update
with the new key values when the type was a 'c',
cascade, for UPDATE triggers, instead of setting
those values to NULL.
Any hints?
Marcus Mascari (mascarim(at)yahoo(dot)com)
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Alex P. Rudnev | 1999-01-29 10:57:46 | Re: [GENERAL] Cascading Updates |
Previous Message | Marcus Mascari | 1999-01-29 09:04:58 | Cascading Updates |