On Mar 12, 8:11 am, alvhe...@xxxxxxxxxxxxxx (Alvaro Herrera) wrote: > Please always ensure that the list is copied on replies (use "Reply to > all") so that other people can help you. > > sam escribió: > > > On Mar 11, 5:39 pm, alvhe...@xxxxxxxxxxxxxxxxx (Alvaro Herrera) wrote: > > > sam escribió: > > > > > Iam not able to understand if this is a version problem or the way iam > > > > using savepoints is wrong.Please advice. > > > > It is. You cannot use savepoints in PL/pgSQL functions (or any function > > > for that matter). You can use EXCEPTION clauses instead. > > Then u please tell me how save points can be used...........The > > program iam working on is throwing an 'LIMIT EXCEEDED' error so iam > > trying to commit data so that a total rollback does not occur.Like > > commiting data after every 1000 transactions. I figured that > > savepoints would be the solution. > > No, savepoints will not help you there. No matter what you do, you > cannot commit in the middle of a function. > > What's the limit being exceeded? Perhaps you can solve your problem > some other way. > > -- > Alvaro Herrera Developer,http://www.PostgreSQL.org/ > "Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio) > > -- > Sent via pgsql-general mailing list (pgsql-gene...@xxxxxxxxxxxxxx) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general Also can u please tell mewhy i get the error...ERROR: SPI_execute_plan failed executing query "PREPARE TRANSACTION 'foo'": SPI_ERROR_TRANSACTION I get this error when i also use COMMIT, ROLLBACK.....does this mean a patch is missing ? Thanks Sam -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
