pgsql: RESET SESSION, plus related new DDL commands.

From: neilc(at)postgresql(dot)org (Neil Conway)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: RESET SESSION, plus related new DDL commands.
Date: 2007-04-12 06:53:49
Message-ID: 20070412065349.3A76D9FBA0B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Log Message:
-----------
RESET SESSION, plus related new DDL commands. Patch from Marko Kreen,
reviewed by Neil Conway. This patch adds the following DDL command
variants: RESET SESSION, RESET TEMP, RESET PLANS, CLOSE ALL, and
DEALLOCATE ALL. RESET SESSION is intended for use by connection
pool software and the like, in order to reset a client session
to something close to its initial state.

Note that while most of these command variants can be executed
inside a transaction block (but are not transaction-aware!),
RESET SESSION cannot. While this is inconsistent, it is intended
to catch programmer mistakes: RESET SESSION in an open transaction
block is probably unintended.

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
close.sgml (r1.24 -> r1.25)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/close.sgml.diff?r1=1.24&r2=1.25)
deallocate.sgml (r1.9 -> r1.10)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/deallocate.sgml.diff?r1=1.9&r2=1.10)
reset.sgml (r1.32 -> r1.33)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/reset.sgml.diff?r1=1.32&r2=1.33)
pgsql/src/backend/catalog:
namespace.c (r1.93 -> r1.94)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/namespace.c.diff?r1=1.93&r2=1.94)
pgsql/src/backend/commands:
async.c (r1.135 -> r1.136)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/async.c.diff?r1=1.135&r2=1.136)
portalcmds.c (r1.62 -> r1.63)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/portalcmds.c.diff?r1=1.62&r2=1.63)
prepare.c (r1.70 -> r1.71)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/prepare.c.diff?r1=1.70&r2=1.71)
pgsql/src/backend/parser:
gram.y (r2.587 -> r2.588)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.587&r2=2.588)
pgsql/src/backend/tcop:
utility.c (r1.276 -> r1.277)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c.diff?r1=1.276&r2=1.277)
pgsql/src/backend/utils/cache:
plancache.c (r1.5 -> r1.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/plancache.c.diff?r1=1.5&r2=1.6)
pgsql/src/backend/utils/misc:
guc.c (r1.383 -> r1.384)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.383&r2=1.384)
pgsql/src/backend/utils/mmgr:
portalmem.c (r1.100 -> r1.101)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mmgr/portalmem.c.diff?r1=1.100&r2=1.101)
pgsql/src/include/catalog:
namespace.h (r1.45 -> r1.46)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/namespace.h.diff?r1=1.45&r2=1.46)
pgsql/src/include/commands:
async.h (r1.34 -> r1.35)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/async.h.diff?r1=1.34&r2=1.35)
prepare.h (r1.25 -> r1.26)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/prepare.h.diff?r1=1.25&r2=1.26)
pgsql/src/include/nodes:
parsenodes.h (r1.344 -> r1.345)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.344&r2=1.345)
pgsql/src/include/utils:
guc.h (r1.80 -> r1.81)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/guc.h.diff?r1=1.80&r2=1.81)
plancache.h (r1.4 -> r1.5)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/plancache.h.diff?r1=1.4&r2=1.5)
portal.h (r1.74 -> r1.75)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/portal.h.diff?r1=1.74&r2=1.75)
pgsql/src/test/regress/expected:
guc.out (r1.2 -> r1.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/guc.out.diff?r1=1.2&r2=1.3)
portals.out (r1.11 -> r1.12)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/portals.out.diff?r1=1.11&r2=1.12)
prepare.out (r1.12 -> r1.13)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/prepare.out.diff?r1=1.12&r2=1.13)
pgsql/src/test/regress/sql:
guc.sql (r1.2 -> r1.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/guc.sql.diff?r1=1.2&r2=1.3)
portals.sql (r1.8 -> r1.9)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/portals.sql.diff?r1=1.8&r2=1.9)
prepare.sql (r1.4 -> r1.5)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/prepare.sql.diff?r1=1.4&r2=1.5)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2007-04-12 07:03:00 pgsql: Enable IPV6 when building with MSVC.
Previous Message User Korryd 2007-04-11 21:46:29 pg-migrator - src: Refactored for simplicity and in preparation for

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-04-12 06:56:44 Re: Vista/IPv6
Previous Message Jeff Frost 2007-04-12 05:33:12 Re: Slow Postgresql server