reset implementation

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: reset implementation
Date: 2012-05-17 15:06:27
Message-ID: CA+mi_8ZpW846xkf8wKxNZo1M0Gbhd_sgUV9-9j1ukTGCDQ-p9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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].

Ok to use DISCARD in reset() (on pg >= 8.3 only)?

[1] http://www.pgpool.net/docs/latest/doc/pgpool-en.html#RESET_QUERY_LIST
[2] http://www.postgresql.org/docs/current/static/sql-discard.html

-- Daniele

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2012-05-17 15:21:20 Re: reset implementation
Previous Message Kryklia Alex 2012-05-16 13:36:31 Re: Question aboud #80 - itersize in cursor dic