pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Transactions and Savepoints
3+ messages / 2 participants
[nested] [flat]

* Transactions and Savepoints
@ 2005-02-08 13:32 Stefan Sturm <mailling@anrath.info>
  2005-02-08 14:33 ` Re: Transactions and Savepoints Tommy Phillips <tommy_pelican@yahoo.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Stefan Sturm @ 2005-02-08 13:32 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Transactions and Savepoints
  2005-02-08 13:32 Transactions and Savepoints Stefan Sturm <mailling@anrath.info>
@ 2005-02-08 14:33 ` Tommy Phillips <tommy_pelican@yahoo.com>
  2005-02-08 19:19   ` Re: Transactions and Savepoints Stefan Sturm <mailling@anrath.info>
  0 siblings, 1 reply; 3+ messages in thread

From: Tommy Phillips @ 2005-02-08 14:33 UTC (permalink / raw)
  To: Stefan Sturm <mailling@anrath.info>; pgsql-php

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Transactions and Savepoints
  2005-02-08 13:32 Transactions and Savepoints Stefan Sturm <mailling@anrath.info>
  2005-02-08 14:33 ` Re: Transactions and Savepoints Tommy Phillips <tommy_pelican@yahoo.com>
@ 2005-02-08 19:19   ` Stefan Sturm <mailling@anrath.info>
  0 siblings, 0 replies; 3+ messages in thread

From: Stefan Sturm @ 2005-02-08 19:19 UTC (permalink / raw)
  To: pgsql-php

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
> 
> 
> 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-02-08 19:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-08 13:32 Transactions and Savepoints Stefan Sturm <mailling@anrath.info>
2005-02-08 14:33 ` Tommy Phillips <tommy_pelican@yahoo.com>
2005-02-08 19:19   ` Stefan Sturm <mailling@anrath.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox