Re: [BUGS] BUG #14590: something wrong when create extension in schema pg_catalog - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14590: something wrong when create extension in schema pg_catalog
Date
Msg-id 2539.1489589360@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14590: something wrong when create extension in schema pg_catalog  (digoal@126.com)
List pgsql-bugs
digoal@126.com writes:
> postgres=# create extension btree_gist with schema pg_catalog;  

I would say that that's neither a good idea nor a supported operation.
If it happens to work in some cases, okay, but you're definitely taking
risks of getting tripped up by the restrictions on pg_catalog...

> ERROR:  42501: permission denied to create "pg_catalog.new_type"  
> DETAIL:  System catalog modifications are currently disallowed.  

... like that one.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: [BUGS] Error floating-point exception on postgresql installer
Next
From: Euler Taveira
Date:
Subject: Re: [BUGS] Differences in COUNT result when enabling parallel query