Re: Begin block

From: "Hajek, Nick" <Nick(dot)Hajek(at)Vishay(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: Begin block
Date: 2009-07-01 18:02:02
Message-ID: AFD16ED07E37C64D963DA24840AA31F2063B8AD7@EVSCO01.na.vishayint.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php


> I'm very much a Postgres PHP novice. I have a number of
> queries that need to be run as a single transaction. One set
> of those will only be run some of the time, but other times
> will need to be imbedded in another block. Can I imbed a
> begin/commit inside another begin/commit?
>

Nested transactions are not allowed in Postgresql you must use
savepoints.

Nick

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Jasen Betts 2009-07-02 09:13:05 Re: Begin block
Previous Message Raymond O'Donnell 2009-07-01 17:57:50 Re: Begin block