Re: rule problem

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: tsmets(at)brutele(dot)be
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: rule problem
Date: 2002-03-25 18:48:10
Message-ID: 200203251848.g2PImAq21496@saturn.janwieck.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tsmets(at)brutele(dot)be wrote:
>
> [...]
>
> I thought I could do smthg like :
> do instead
> begin work
> Action_1;
> Action_2;
> Action_3;
> commit work
>
> Could some one suggest a better solution ?
> I have never seen what happens if I set multiple rules.
> Are they applied in the order they were created ?

You cannot and don't need to do BEGIN and COMMIT as rule
actions. Write it as

do instead
(
Action_1;
Action_2;
Action_3;
);

and the actions will be perfomed in that order, all in one
and the same transaction.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-03-25 19:38:28 Re: BUG? - Sequence got verry strange id
Previous Message Neil Conway 2002-03-25 18:45:16 Re: Another notify question