PostgreSQL multiple transactions on the same connection

Question

Does PostgreSQL support multiple transactions on the same connection? I don't mean nested transactions, but unrelated different transactions.

Multiple concurrent transactions on the same connection? No. — Craig Ringer
– Craig Ringer, Commented Jul 24, 2012 at 0:24
similar question. Does PostgreSQL support the execution of multiple queries within a single database connection? — Yene Mulatu
– Yene Mulatu, Commented Mar 7, 2024 at 1:05

A.H. · Accepted Answer · 2012-07-23 21:19:04Z

9

If you mean "interleaved transactions" as required by the Java JTA standard: No, there is no support for that. See this JDBC FAQ section for this and why it is not a big loss.

Also the PostgreSQL core does not support something like this.

answered Jul 23, 2012 at 21:19

A.H.

66.8k16 gold badges97 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yene Mulatu Over a year ago

The link is not working.

user330315 · Accepted Answer · 2012-07-23 21:12:00Z

8

If with unrelated you mean one after the other, then the answer is yes.

If you mean having different transactions open at the same time, then the answer is no (there are some hacks available using dblink but I don't think they qualify as "on the same connection).

answered Jul 23, 2012 at 21:12

user330315

Collectives™ on Stack Overflow

PostgreSQL multiple transactions on the same connection

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related