Re: Rules and transactions - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Rules and transactions
Date
Msg-id 200101242300.SAA02766@jupiter.greatbridge.com
Whole thread Raw
In response to Rules and transactions  (Brett Schwarz <schwarz@PacketVideo.COM>)
List 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@Yahoo.com #



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



pgsql-sql by date:

Previous
From: clayton cottingham
Date:
Subject: Veering OT opinions please XQL versus XML-QL
Next
From: "Glen and Rosanne Eustace"
Date:
Subject: Re: Problem with Dates