From 76d872716abb5acf291c328b1894a06f1ccfabd3 Mon Sep 17 00:00:00 2001 From: Pavan Deolasee Date: Mon, 22 Jun 2015 15:39:24 +0530 Subject: [PATCH] Mark a table in rowsecurity test case to be replicated The table is referenced by another table on a non-distribution key. So mark the table as replicated --- src/test/regress/sql/rowsecurity.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/src/test/regress/sql/rowsecurity.sql b/src/test/regress/sql/rowsecurity.sql index fdadf99fd6..55fa7b8bf8 100644 --- a/src/test/regress/sql/rowsecurity.sql +++ b/src/test/regress/sql/rowsecurity.sql @@ -53,10 +53,14 @@ INSERT INTO uaccount VALUES ('rls_regress_user2', 2), ('rls_regress_user3', 3); +-- PGXL +-- Distribute by replication so that "document" table below can reference "cid" +-- column +-- CREATE TABLE category ( cid int primary key, cname text -); +) DISTRIBUTE BY REPLICATION; GRANT ALL ON category TO public; INSERT INTO category VALUES (11, 'novel'), -- 2.39.5