On Sun, 2007-01-07 at 09:59 +0100, Pavel Stehule wrote: > PostgreSQL allow only catch exception (elevel ERROR). SQL/PSM requires that > warnings are catchable too. Simply solution's is adding one callback to > error's processing of errors on level WARNING.
Exceptions are run within their own subtransaction, so the exception handling code runs separately. Does the PSM warning error handler run in the same transaction or a separate subtransaction? Can transaction execution continue afterwards? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
