[GENERAL] Re: One transaction by connection - commit subdetails without release master transaction?
Dear Anybody! I replace the long question to some shorter: As I see the PGSQL supports one transaction per connection. Is this information ok? Formerly I believed that only Zeos/PGDAC supports one trs/conn, but now it seems to be based on the server, and not the components... (The pgadmin is also showing one tx state/statement per connection) So if I want to make two transactions in client am I must duplify the connections in this period? Thanks for your help: dd 2012/2/17 Durumdara durumd...@gmail.com: Dear PGSQL Masters! What do you thinking about this? Can I do this without doubling the connections by users (if I duplicate the connections, the subforms can use the second connection = another transaction)? Thanks for your help: dd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Re: One transaction by connection - commit subdetails without release master transaction?
On Feb 29, 2012, at 4:11 AM, Durumdara wrote: Dear Anybody! I replace the long question to some shorter: As I see the PGSQL supports one transaction per connection. Is this information ok? Yes, in postgres a connection can support only one transaction. If you wish to reduce the number of connections, look into a connection pooler, such as pgBouncer. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Re: One transaction by connection - commit subdetails without release master transaction?
On 29 Feb 2012, at 20:44, Ben Chobot wrote: As I see the PGSQL supports one transaction per connection. Is this information ok? Yes, in postgres a connection can support only one transaction. A small correction: a connection can support only one transaction _simultaneously_. You can serialise transactions on one connection just fine. Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Re: One transaction by connection - commit subdetails without release master transaction?
On Feb 29, 2012, at 3:00 PM, Alban Hertroys wrote: On 29 Feb 2012, at 20:44, Ben Chobot wrote: As I see the PGSQL supports one transaction per connection. Is this information ok? Yes, in postgres a connection can support only one transaction. A small correction: a connection can support only one transaction _simultaneously_. You can serialise transactions on one connection just fine. Heh, woops, yes, that's a good correction to make. :) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general