pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedTransactions and Savepoints
3+ messages / 2 participants
[nested] [flat]
* Transactions and Savepoints
@ 2005-02-08 13:32 Stefan Sturm <mailling@anrath.info>
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 14:33 Tommy Phillips <tommy_pelican@yahoo.com>
parent: 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 19:19 Stefan Sturm <mailling@anrath.info>
parent: Tommy Phillips <tommy_pelican@yahoo.com>
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