On Thu, Apr 14, 2005 at 04:10:18PM -0400, Ying Lu wrote: > I'd like to know is it possible to use "SAVEPOINT" in a function? In the > following example, I got an error when calling this function: No; exceptions in plpgsql are implemented internally using savepoints, so the function will automatically roll back the whole "begin ... end" block (remember you can nest blocks if needed.) -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "Java is clearly an example of a money oriented programming" (A. Stepanov) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org