Postgres Pro
Downloads
Home   >   mailing lists

how to use savepoint and rollback in function - Mailing list pgsql-general

From tushar nehete
Subject how to use savepoint and rollback in function
Date
Msg-id AANLkTikBKPa-uvrCsjxkTmEhMbBZf8GeHApKvkZ=Lu_j@mail.gmail.com
Whole thread Raw
Responses Re: how to use savepoint and rollback in function  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: how to use savepoint and rollback in function  (dhaval jaiswal <dhavallj@hotmail.com>)
List pgsql-general
Tree view
Hi All,
In Postgresql we can use savepoint and rollback to savepoint in transaction.
But we cannot use savepoint in function.
Currently I am doing migration from Informix to Postgresql 8.4.
In Informix they used Savepoint.
Please advice how to use Savepoint and rollback to savepoint in function.
I know Postgresql has autocommit. But I want to rollback to a particular savepoint.
 
Thanks & Regards,
Tushar

pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...
Next
From: Alban Hertroys
Date:
Subject: Re: A join of 2 tables with sum(column) > 30