psycopg2: re-using connection object after connection closing

Question

I could not find a way to re-use a connection object. After executing conn.close() I still have the object in memory so there must be a way to re-use it. What's the best way to do it?

You don't have the connection to the database open anymore. What would you like to do with the connection object that doesn't involve the database? — user707650
– user707650, Commented Jul 17, 2013 at 14:27

Clodoaldo Neto · Accepted Answer · 2013-07-17 14:27:14Z

3

From the connection class documentation:

close()

Close the connection now (rather than whenever del is executed). The connection will be unusable from this point forward; an InterfaceError will be raised if any operation is attempted with the connection

answered Jul 17, 2013 at 14:27

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

2 Comments

casper Over a year ago

Does it mean that every time I create a new connection the old one stays in memory?

user707650 Over a year ago

Not if you assign the new connection to the same variable; then the object (and memory) gets overwritten. What's the worry though? A closed connection object won't exhaust your memory.

Collectives™ on Stack Overflow

psycopg2: re-using connection object after connection closing

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related