这是indexloc提供的服务,不要输入任何密码
Skip to content

SQL displayed for publication is missing row filters. #5868

@bctrigg

Description

@bctrigg

Using PgAdmin4 6.20 / Postgres 15.2

Create a table per the example in https://www.postgresql.org/docs/current/logical-replication-row-filter.html.:

CREATE TABLE t1(a int, b int, c text, PRIMARY KEY(a,c));

Create a publication per the example:

CREATE PUBLICATION p1 FOR TABLE t1 WHERE (a > 5 AND c = 'NSW');

Select the publication in PgAdmin, SQL tab shows the following, rows filters have been removed:

-- Publication: p1

-- DROP PUBLICATION IF EXISTS p1;

CREATE PUBLICATION p1
FOR TABLE public.t1
WITH (publish = 'insert, update, delete, truncate', publish_via_partition_root = false);

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions