Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

psycopg by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group