Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Begin block



> 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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group