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

pgsql/src/backend/commands sequence.c

From: tgl(at)postgresql(dot)org
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src/backend/commands sequence.c
Date: 2002-01-11 18:16:08
Message-ID: 200201111816.g0BIG8c80532@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql
Changes by:	tgl(at)postgresql(dot)org	02/01/11 13:16:04

Modified files:
	src/backend/commands: sequence.c 

Log message:
	Fix sequence creation to set the t_xmin of a sequence's tuple to
	FrozenTransactionId, not the XID of the creating transaction.  Without
	this it's possible for a reference to a long-gone CLOG record to occur,
	per Christian Meunier's bug report of 10-Jan-02.  Worse, the sequence
	tuple would become invisible to SELECTs after 2 billion transactions.
	
	Since the fix is applied during sequence creation it does not help
	existing databases, unless you drop and recreate every sequence.
	However, we intend to force initdb for 7.2RC1 anyway, to fix a pg_proc
	error, so I see no need to do more for this problem.


Responses

pgsql-committers by date

Next:From: Bruce MomjianDate: 2002-01-11 19:22:34
Subject: Re: pgsql/src/backend/commands sequence.c
Previous:From: meskesDate: 2002-01-11 14:43:12
Subject: pgsql/src/interfaces/ecpg ChangeLog lib/descri ...

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