From e9cda08b2b79303e36594e1d4e5e09ea2db84b6a Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 12 Jun 2003 07:49:43 +0000
Subject: Brief note about sequence cache not being cleared in other backends.

Actually clear the cache in the backend making the alteration.  This
follows in the footsteps of setval().

Rod Taylor
---
 src/backend/commands/sequence.c | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'src/backend/commands/sequence.c')

diff --git a/src/backend/commands/sequence.c b/src/backend/commands/sequence.c
index 308ee213105..cb494826308 100644
--- a/src/backend/commands/sequence.c
+++ b/src/backend/commands/sequence.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/commands/sequence.c,v 1.95 2003/03/21 03:55:21 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/commands/sequence.c,v 1.96 2003/06/12 07:49:43 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -345,6 +345,11 @@ AlterSequence(AlterSeqStmt *stmt)
 		seq->log_cnt = 1;
 	}
 
+	/* save info in local cache */
+	elm->last = new.last_value;		/* last returned number */
+	elm->cached = new.last_value;	/* last cached number (forget cached
+									 * values) */
+
 	START_CRIT_SECTION();
 
 	/* XLOG stuff */
-- 
cgit v1.2.3