From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | Fabrizio Mazzoni <fabrizio(at)macron(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Transactions in rules.. |
Date: | 2001-07-09 16:09:10 |
Message-ID: | Pine.BSO.4.10.10107091208560.13870-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Cannot do this, as currently there is no support for nested transactions.
On Mon, 9 Jul 2001, Fabrizio Mazzoni wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-07-09 16:34:31 | Upcoming events in July |
Previous Message | Robert Berger | 2001-07-09 16:00:49 | Re: Re: query optimizer questions |