| 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
| 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 |