Cascading Updates

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

Browse pgsql-general by date

  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