A question for v58-0002.

======
src/test/regress/expected/subscription.out

+-- Trying to create a new table manually in the pg_conflict namespace
+-- This should fail as the namespace is reserved for conflict log tables
+CREATE TABLE pg_conflict.manual_table (id int);
+ERROR:  permission denied for schema pg_conflict
+LINE 1: CREATE TABLE pg_conflict.manual_table (id int);
+                     ^

Why is that error very different from the error received when
attempting the same thing for `pg_catalog` schema?
Shouldn't the errors in both cases be almost the same?

Here:
- LINE is shown
- A schema error happens instead of a create table error

OTOH, the similar case for pg_catalog looks like:
test_pub=# create table pg_catalog.t1(a int);
ERROR:  permission denied to create "pg_catalog.t1"
DETAIL:  System catalog modifications are currently disallowed.

======
Kind Regards,
Peter Smith.
Fujitsu Australia


Reply via email to