pgsql: Add a new reloption, user_catalog_table.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a new reloption, user_catalog_table.
Date: 2013-12-11 00:34:47
Message-ID: E1VqXlH-0008EX-EW@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Add a new reloption, user_catalog_table.

When this reloption is set and wal_level=logical is configured,
we'll record the CIDs stamped by inserts, updates, and deletes to
the table just as we would for an actual catalog table. This will
allow logical decoding to use historical MVCC snapshots to access
such tables just as they access ordinary catalog tables.

Replication solutions built around the logical decoding machinery
will likely need to set this operation for their configuration
tables; it might also be needed by extensions which perform table
access in their output functions.

Andres Freund, reviewed by myself and others.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/66abc2608c7c00fcd449e00a9e23f13f02e65d04

Modified Files
--------------
src/backend/access/common/reloptions.c | 10 ++++++++++
src/backend/commands/tablecmds.c | 6 ++++++
src/include/utils/rel.h | 16 ++++++++++++++--
3 files changed, 30 insertions(+), 2 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2013-12-11 00:54:36 Re: [COMMITTERS] pgsql: Add a new reloption, user_catalog_table.
Previous Message Robert Haas 2013-12-11 00:07:23 pgsql: Add new wal_level, logical, sufficient for logical decoding.

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-12-11 00:35:44 Re: logical changeset generation v6.8
Previous Message Andres Freund 2013-12-11 00:34:44 Re: Why we are going to have to go DirectIO