| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Nilabhra Banerjee <nil_ban(at)yahoo(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Is it not possible to nest one block within another? |
| Date: | 2003-12-02 12:42:18 |
| Message-ID: | 200312021242.hB2CgIu15334@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Nilabhra Banerjee wrote:
> Hi,
>
> I have learnt from mailing archives that nested
> transaction is not possible in postgresql. I then
> thought, in nested blocks, the inner block must be
> having autonomous transaction (As is pragma autonomous
> transaction in Oracle 8i). But I found postgresql is
> able to identify only the outer begin-end pair and
> just ignoring (with a warning) all other inner begin
> -end blocks. Is it natural of postgresql or I am
> making some mistake?
We don't supported nested transactions yet, but hope to soon.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2003-12-02 13:14:04 | Re: Misplaced modifier in Postgresql license |
| Previous Message | Netto | 2003-12-02 12:39:32 | Re: How to obtain the real problem that avoids postgresql service starting? |