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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: digoal(at)126(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14590: something wrong when create extension in schema pg_catalog
Date: 2017-03-15 14:49:20
Message-ID: 2539.1489589360@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

digoal(at)126(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Euler Taveira 2017-03-15 15:33:33 Re: Differences in COUNT result when enabling parallel query
Previous Message Sandeep Thakkar 2017-03-15 14:07:08 Re: Error floating-point exception on postgresql installer