cockroachdb / cockroachdb/docs

Feedback: MOLT Fetch - document required permissions to add a table to a publication for Postgres

Open
#20,162 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
HTML
Stars
212
Forks
476
Avg merge
40m
Merged PRs (30d)
3

Description

Page: https://cockroachlabs.com/docs/molt/molt-fetch.html

## What is the reason for your feedback?

[X] Missing the information I need

[ ] Too complicated

[ ] Out of date

[ ] Something is broken

[ ] Other

## Additional details

Postgres docs say

https://www.postgresql.org/docs/current/sql-createpublication.html

> To add a table to a publication, the invoking user must have ownership rights on the table. The FOR ALL TABLES and FOR TABLES IN SCHEMA clauses require the invoking user to be a superuser.

This requirement is not documented in the MOLT Fetch docs.

Otherwise the customer will get the following error:

> Error: ERROR: must be owner of table referral_pending (SQLSTATE 42501)

Jira issue: DOC-14620

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.