pgsql: When a relation is moved to another tablespace, we can't assume

From: heikki(at)postgresql(dot)org (Heikki Linnakangas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: When a relation is moved to another tablespace, we can't assume
Date: 2008-10-07 11:15:48
Message-ID: 20081007111548.1E60C7545A4@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
When a relation is moved to another tablespace, we can't assume that we can
use the old relfilenode in the new tablespace. There might be another relation
in the new tablespace with the same relfilenode, so we must generate a fresh
relfilenode in the new tablespace.

The 8.3 patch to let deleted relation files linger as zero-length files until
the next checkpoint made this more obvious: moving a relation from one table
space another, and then back again, caused a collision with the lingering
file.

Back-patch to 8.1. The issue is present in 8.0 as well, but it doesn't seem
worth fixing there, because we didn't have protection from OID collisions
after OID wraparound before 8.1.

Report by Guillaume Lelarge.

Tags:
----
REL8_3_STABLE

Modified Files:
--------------
pgsql/src/backend/commands:
tablecmds.c (r1.242.2.3 -> r1.242.2.4)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.242.2.3&r2=1.242.2.4)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-10-07 11:15:54 pgsql: When a relation is moved to another tablespace, we can't assume
Previous Message Heikki Linnakangas 2008-10-07 11:15:41 pgsql: When a relation is moved to another tablespace, we can't assume