Savepoint Problem - Mailing list pgsql-general

From Stefan Sturm
Subject Savepoint Problem
Date
Msg-id 41F4CEAC.20704@anrath.info
Whole thread Raw
In response to Weird problem in 8.0.0  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-general
Hello,

I have a function, which stores some Data. Sometimes this function is
called within a transaction an sometimes not. But I need to set a
savepoint in this function. But this is my problem, when I'm not in a
transaction I get this error:

ERROR:  SAVEPOINT may only be used in transaction blocks

How can I check, if there is an transaction?

Thanks for your help,
Stefan Sturm


pgsql-general by date:

Previous
From: William Yu
Date:
Subject: Re: serialization errors when inserting new records
Next
From: Ralph van Etten
Date:
Subject: Re: serialization errors when inserting new records