On Tuesday 13 February 2007 17:31, Uwe Grauer wrote:
> johnf wrote:
> > On Tuesday 13 February 2007 17:04, Paul McNett wrote:
> >> Uwe Grauer wrote:
> >>> Yes,
> >>> sometime you want to serialize things or just want to make sure things
> >>> are isolated from other operations.
> >>> I will see if i can establish something without messing with the things
> >>> we have now.
> >>
> >> And if you come up with something generic, please consider submitting a
> >> patch.
> >
> > Yes please do and please take into consideration that psycopg uses
> > connection pooling for every cursor created.
>
> In firebird a transaction is bound to a connection.
> How does psycopg use connection pooling for every cursor?
> Is a transaction in postgres cursor-bound?
No - not from what I understand. BTW it's not that Postgres is pooling it is
the driver psycopg that is doing the pooling.
so:
conn=psycopg2.connect("dbname='foo' user='dbuser' password='mypass'")
cur1 = conn.cursor()
cur2 = conn.cursor()
Will be two connections one for each of the cursors.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
