Re: closing a connection from "outside" an application (for testing)

Federico Di Gregorio <fog-NGVKUo/i/[email protected]>
Newsgroups gmane.comp.python.db.psycopg.devel
Organization initd.org
Message-ID <[email protected]>
Il giorno gio, 03/01/2008 alle 21.26 -0800, Webb Sprague ha scritto:
> Is there a way for psycopg to return the PID of the process it is
> connected to, primarily for logging (and killing)?  I am still trying
> to figure out how to stop a run of my program in mid-stream (besides a
> sleep() or waiting on a signal...), but that will get me started.

No way, right now (unless you can do that using a query; I don't know.)

> Also -- if the program running psycopg2 dies, what happens to the
> "idle in transaction" postgres process?

The transaction is aborted and the process exits.

federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                [email protected]
INIT.D Developer                                           fog-NGVKUo/i/[email protected]
                           Don't dream it. Be it. -- Dr. Frank'n'further

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBHfmsWvcCgrgZGjesRAj8iAKCRapf8HSD+JN1hgV40KNN72yZAGACfWVT/
x+W4+S05Zoxtn9HRM992Thw=
=5Y4R
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.