On Fri, Nov 2, 2012 at 1:57 PM, Dongkuo Ma <luc.mdk@xxxxxxxxx> wrote: > Hi > the python code is > > logging.info("database connecting...") > conn = connect(database="dbname", user="user", > password="password",host="127.0.0.1") > logging.info("database connected") > conn.autocommit = True > conn.set_client_encoding('UTF8') > cur = conn.cursor() > #the above code executed without exception > #and [server closed the connection unexpectedly] thrown when any > cur.execute() called > I think it's strange because the server reset connection after connected,and > the connect function should throw a exception. > > It's nothing in the log file. Is there a long delay between connecting and executing a query? It may be that something disconnected you during that time. Or could the server have been restarted? Can you make a simple Python script that always fails in this way? Chris Angelico -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general