Re: reset implementation - Mailing list psycopg

From Federico Di Gregorio
Subject Re: reset implementation
Date
Msg-id 4FB51770.2050407@dndg.it
Whole thread Raw
In response to reset implementation  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Responses Re: reset implementation
List psycopg
On 17/05/12 17:06, Daniele Varrazzo wrote:
> Hello
>
> psycopg implements the connection.reset() method using the commands
> RESET ALL and SET SESSION AUTHORIZATION DEFAULT.
>
> Reading pgpool2 docs [1], I see that from PG 8.3 "DISCARD ALL" would
> be more appropriate: it is equivalient to RESET ALL and SET SESSION
> AUTHORIZATION DEFAULT plus more [2].

What bothers me is that executes the equivalent of:

UNLISTEN *;

IMHO that's correct for connection.reset() but I don't know how many
people out there are using NOTIFY and .reset() togheter and I don't want
to break their code.

federico

--
Federico Di Gregorio                         federico.digregorio@dndg.it
Studio Associato Di Nunzio e Di Gregorio                  http://dndg.it
 And anyone who yells "fork" deserves to get one stuck in them.
                                                          -- Dan Winship

psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: reset implementation
Next
From: Daniele Varrazzo
Date:
Subject: Re: reset implementation