BUG #14590: something wrong when create extension in schema pg_catalog

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14590: something wrong when create extension in schema pg_catalog
Date: 2017-03-15 12:13:40
Message-ID: 20170315121340.1424.60144@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14590
Logged by: Zhou Digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: 9.6.2
Operating system: CentOS 6.x x64
Description:

```
cd $PGHOME/share/extension

cp btree_gist--1.2.sql btree_gist--9.9.9.sql

vi btree_gist--9.9.9.sql
-- add this
create type new_type as (
id int,
c1 int
);
```

test

```
postgres=# create extension btree_gist with schema pg_catalog;
CREATE EXTENSION
postgres=# drop extension btree_gist ;
DROP EXTENSION

postgres=# \set VERBOSITY verbose
postgres=# create extension btree_gist with schema pg_catalog version
'9.9.9';
ERROR: 42501: permission denied to create "pg_catalog.new_type"
DETAIL: System catalog modifications are currently disallowed.
LOCATION: heap_create, heap.c:280
```

but why can do this?

```
postgres=# create extension btree_gist version '9.9.9';;
CREATE EXTENSION
postgres=# alter extension btree_gist set schema pg_catalog;
ALTER EXTENSION
```

and why can do this?

```
vi $PGDATA/postgresql.conf
allow_system_table_mods=on

pg_ctl restart -m fast

postgres=# create extension btree_gist with schema pg_catalog version
'9.9.9';
CREATE EXTENSION
```

table, composite type, seq ... in extension sql, so cann't create in
pg_catalog?

it's a bug?

best regards
digoal

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2017-03-15 14:07:08 Re: Error floating-point exception on postgresql installer
Previous Message Dave Page 2017-03-15 11:55:11 Re: Error floating-point exception on postgresql installer