pgsql: Drop no-longer-needed buffers during ALTER DATABASE SET TABLESPA - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Drop no-longer-needed buffers during ALTER DATABASE SET TABLESPA
Date
Msg-id E1Xlin7-0003wN-LS@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Drop no-longer-needed buffers during ALTER DATABASE SET TABLESPACE.

The previous coding assumed that we could just let buffers for the
database's old tablespace age out of the buffer arena naturally.
The folly of that is exposed by bug #11867 from Marc Munro: the user could
later move the database back to its original tablespace, after which any
still-surviving buffers would match lookups again and appear to contain
valid data.  But they'd be missing any changes applied while the database
was in the new tablespace.

This has been broken since ALTER SET TABLESPACE was introduced, so
back-patch to all supported branches.

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f88300168b1c5786c4b167de17e1a0bbb252337e

Modified Files
--------------
src/backend/commands/dbcommands.c |   17 +++++++++++++++++
1 file changed, 17 insertions(+)


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Remove support for 64-bit CRC.
Next
From: Tom Lane
Date:
Subject: pgsql: Drop no-longer-needed buffers during ALTER DATABASE SET TABLESPA