pgsql: Add a new reloption, user_catalog_table.
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(-)
--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
On Wed, Dec 11, 2013 at 9:34 AM, Robert Haas <rhaas@postgresql.org> wrote:
Add a new reloption, user_catalog_table.
Sorry for not having completely followed the thread of logical
replication, but wouldn't this deserve some documentation?
Regards,
--
Michael
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 2013-12-11 09:54:36 +0900, Michael Paquier wrote:
On Wed, Dec 11, 2013 at 9:34 AM, Robert Haas <rhaas@postgresql.org> wrote:
Add a new reloption, user_catalog_table.
Sorry for not having completely followed the thread of logical
replication, but wouldn't this deserve some documentation?
I'd say this needs to be documented when the later facilities are
committed. It seems hard to explain without that context.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Tue, Dec 10, 2013 at 7:56 PM, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-12-11 09:54:36 +0900, Michael Paquier wrote:
On Wed, Dec 11, 2013 at 9:34 AM, Robert Haas <rhaas@postgresql.org> wrote:
Add a new reloption, user_catalog_table.
Sorry for not having completely followed the thread of logical
replication, but wouldn't this deserve some documentation?I'd say this needs to be documented when the later facilities are
committed. It seems hard to explain without that context.
I actually think Michael is right. There's no reason this can't or
shouldn't get a mention in <title
id="SQL-CREATETABLE-storage-parameters-title">Storage
Parameters</title> at the very least. We might not have the right
stuff to hyperlink to for more details yet, but we can at least get
the basic bits in there.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers