Transactions in rules..

From: "Fabrizio Mazzoni" <fabrizio(at)macron(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Transactions in rules..
Date: 2001-07-09 14:04:05
Message-ID: 000201c10880$04abf960$4f00a8c0@fabrizio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can i use transactions in rules??
I was trying something like:

create rule x_test as
on insert to view1
do instead
(
begin;
insert into test1 values (new.a,new.b);
insert into test2 values (new.c,new.d);
commit;
);

But when i give this command in psql i always get an error..

Regards

fabrizio(at)macrongolf(dot)com
http://macrongolf.com
http://eteampoint.com
http://macron.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-07-09 14:08:02 Re: [GENERAL] Re: QUERY - Including the new LDP PostgreSQL HOWTO in the main PostgreSQL distribution
Previous Message Jan Wieck 2001-07-09 13:52:12 Re: trigger: NEW/OLD-error or nothing happens