Postgres Pro
Downloads
Home   >   mailing lists

Thread: Transactions and Savepoints

Transactions and Savepoints

From
Stefan Sturm
Date:
Hello,

I have a problem with savepoints.

I have a function which does some DB changed. This changes have to be in
  a single Transaction. This function is now called in two different
ways. Once within a transaction and once not in a transaction. But how
can i check if I am within a transaction, so I  can start a new
transaction or set a savepoint.

Is there a way to check this?

Thanks and Greetings,

Stefan Sturm

Re: Transactions and Savepoints

From
Tommy Phillips
Date:
Stefan-

We will need more information:

What DBMS are you using, what version and what version
of PHP, for starters.

--- Stefan Sturm <mailling@anrath.info> wrote:

> Hello,
>
> I have a problem with savepoints.
>
> I have a function which does some DB changed. This
> changes have to be in
>   a single Transaction. This function is now called
> in two different
> ways. Once within a transaction and once not in a
> transaction. But how
> can i check if I am within a transaction, so I  can
> start a new
> transaction or set a savepoint.
>
> Is there a way to check this?
>
> Thanks and Greetings,
>
> Stefan Sturm
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


=====
---------------------------
Tommy Phillips
303-427-8456 (Home)
303-981-4310 (Cell)
tommyp@acm.org

Re: Transactions and Savepoints

From
Stefan Sturm
Date:
Oh Sorry, my fault.
PostgreSQL 8.0
php 5.0.3

Hope this helps.

Thanks,
Stefan Sturm

Tommy Phillips schrieb:
> Stefan-
>
> We will need more information:
>
> What DBMS are you using, what version and what version
> of PHP, for starters.
>
> --- Stefan Sturm <mailling@anrath.info> wrote:
>
>
>>Hello,
>>
>>I have a problem with savepoints.
>>
>>I have a function which does some DB changed. This
>>changes have to be in
>>  a single Transaction. This function is now called
>>in two different
>>ways. Once within a transaction and once not in a
>>transaction. But how
>>can i check if I am within a transaction, so I  can
>>start a new
>>transaction or set a savepoint.
>>
>>Is there a way to check this?
>>
>>Thanks and Greetings,
>>
>>Stefan Sturm
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faq
>>
>
>
>
> =====
> ---------------------------
> Tommy Phillips
> 303-427-8456 (Home)
> 303-981-4310 (Cell)
> tommyp@acm.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
>
>