From c0e42e9325949a692d0803331e60ae87d2f76684 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 12 Apr 2007 19:38:26 +0000 Subject: [PATCH] Done: > * -Add RESET SESSION command to reset all session state --- doc/TODO | 15 ++------------- doc/src/FAQ/TODO.html | 14 ++------------ 2 files changed, 4 insertions(+), 25 deletions(-) diff --git a/doc/TODO b/doc/TODO index a1111396cc..e6e3d69bd2 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Wed Apr 11 17:02:21 EDT 2007 +Last updated: Thu Apr 12 15:38:17 EDT 2007 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -521,18 +521,7 @@ SQL Commands * Add NOVICE output level for helpful messages like automatic sequence/index creation -* Add RESET CONNECTION command to reset all session state - - This would include resetting of all variables (RESET ALL), dropping of - temporary tables, removing any NOTIFYs, cursors, open transactions, - prepared queries, currval()s, etc. This could be used for connection - pooling. We could also change RESET ALL to have this functionality. - The difficult of this features is allowing RESET ALL to not affect - changes made by the interface driver for its internal use. One idea - is for this to be a protocol-only feature. Another approach is to - notify the protocol when a RESET CONNECTION command is used. - http://archives.postgresql.org/pgsql-patches/2006-04/msg00192.php - +* -Add RESET SESSION command to reset all session state * Add GUC to issue notice about statements that use unjoined tables * Allow EXPLAIN to identify tables that were skipped because of constraint_exclusion diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index d48daa09a5..e183a78fe7 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Wed Apr 11 17:02:21 EDT 2007 +Last updated: Thu Apr 12 15:38:17 EDT 2007

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -464,17 +464,7 @@ first. There is also a developer's wiki at

  • Add NOVICE output level for helpful messages like automatic sequence/index creation -
  • Add RESET CONNECTION command to reset all session state -

    This would include resetting of all variables (RESET ALL), dropping of - temporary tables, removing any NOTIFYs, cursors, open transactions, - prepared queries, currval()s, etc. This could be used for connection - pooling. We could also change RESET ALL to have this functionality. - The difficult of this features is allowing RESET ALL to not affect - changes made by the interface driver for its internal use. One idea - is for this to be a protocol-only feature. Another approach is to - notify the protocol when a RESET CONNECTION command is used. - http://archives.postgresql.org/pgsql-patches/2006-04/msg00192.php -

    +
  • -Add RESET SESSION command to reset all session state
  • Add GUC to issue notice about statements that use unjoined tables
  • Allow EXPLAIN to identify tables that were skipped because of constraint_exclusion -- 2.40.0