Re: Rules and transactions

From: Jan Wieck <janwieck(at)Yahoo(dot)com>
To: Brett Schwarz <schwarz(at)PacketVideo(dot)COM>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Rules and transactions
Date: 2001-01-24 23:00:03
Message-ID: 200101242300.SAA02766@jupiter.greatbridge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Brett Schwarz wrote:
> If I have a rule, is the rule inside a tranaction along with the table that
> it references. For example, if I have a rule that deletes an entry from
> table B, whenever an entry in table A gets deleted, then is the delete for
> table A and table B wrapped inside the same transaction?
>
> Same question I guess goes for triggers.

Yes and yes. Both solutions are strictly covered by
transactions.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Glen and Rosanne Eustace 2001-01-25 02:06:38 Re: Problem with Dates
Previous Message Kyle 2001-01-24 22:14:32 Rule not invoked in 7.1