Thread: More than one transaction at the same time

More than one transaction at the same time

From
Yury Don
Date:
Hi All!

Can I start 2 or more transactions simultaneously?
Task is in the following: I am startig transaction with the "begin",
then declare a cursor. Then I need to start another transaction in order
to do some things, but I don't want to close first transaction because
later I need to fetch frome created cursor.
Or I understand something wrongly?

Sincerely yours, Yury.
don.web-page.net, ICQ 11831432

Re: [GENERAL] More than one transaction at the same time

From
Bruce Momjian
Date:
[Charset koi8-r unsupported, filtering to ASCII...]
> Hi All!
>
> Can I start 2 or more transactions simultaneously?
> Task is in the following: I am startig transaction with the "begin",
> then declare a cursor. Then I need to start another transaction in order
> to do some things, but I don't want to close first transaction because
> later I need to fetch frome created cursor.
> Or I understand something wrongly?

We don't support nested transactions yet.
--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026