On Tuesday, November 08, 2011 7:13:03 am Lori Corbani wrote: > Richard, > > I manage to find one comment about an implicit rollback in a section of > the developer's guide when porting from Oracle-to-Postgres: "when an > exception is caught by an EXECPTION clause, all database changes since > the block's BEGIN are automatically rolled back" > > Do you know of any other place in the documentation this discusses the > implicit rollback in more detail? Or do you know of a good online site > that contains some good examples or best-practices for these > function-to-function calls?
http://www.postgresql.org/docs/9.0/interactive/plpgsql-control- structures.html#PLPGSQL-ERROR-TRAPPING > > We are starting to port our Sybase database (200 stored procedures) over > to Postgres and I am finding the online Postgres documentation and the > Douglas book a bit lacking in some of the more specific examples that I > am interested in finding. > > Thanks. > Lori > > > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
