Hello Jason,
thanks for your questions. I will try to answer:
WinXp Pro, x86, python 2.7 32bit, pygtk, latest version of psycopg2, py/gtk 2.24.0
ad __del__() - No. It closes connections wher at the end of timer interval (every few minutes it checks data in db and closes connections). I am not using SSL mode. But I found out when I import psycopg2 after gtk import it shows that error on exit but when I import psycopg2 before gtk it seems to work fine.
example with error:
import pygtk
pygtk.require("2.0")
import gtk
import psycopg2
import psycopg2.extras
example without error:
import psycopg2
import psycopg2.extras
import pygtk
pygtk.require("2.0")
import gtk
it is strange but I am happy it works now. however I would like to know if it is bug or not. thanks.
--Peter
2012/1/11 Jason Erickson
<jason.erickson@stickpeople.com>A few quick questions, then I can try and duplicate the issue:
* What Windows version are you running the program on (ie, XP, Windows 7) and what architecture (x86, x64)?
* What Python GUI framework are you using (and version)?
* What Python version & architecture?
* Are the self.cur.close() and self.con.close() calls inside the __del__() method of your object (ie, are they being called when the object is destroyed, or do you have a method in your object such as 'close' that closes the connections when the button is pressed?
* Are you including/using SSL in your code, via psycopg (by using the sslmode parameter on the connection), and/or by using https in httplib, or including ssl?
* Any other nonstandard lib modules being imported in your code?
-jason
On Wed, Jan 11, 2012 at 7:21 AM, Peter Irbizon
<peterirbizon@gmail.com> wrote:
Hello, I am using psycopg2 in windows app for example:
import psycopg2
import psycopg2.extras
self.con = psycopg2.connect("dbname= host= user= password= port=");
self.cur = self.con.cursor(cursor_factory=psycopg2.extras.DictCursor)
SELECT = "select something"
self.cur.execute(SELECT)
for row in self.cur:
...
self.cur.close()
self.con.close()
But when I click on exit button in application MS Visual C++ runtime library error occurs: This application has requested the runtime to terminate it in unusual way.
What am I doing wrong?