Postgres Pro
Downloads
Home   >   mailing lists

Re: What db objects can only be created with superuser? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: What db objects can only be created with superuser?
Date
Msg-id 1679716.1732637756@sss.pgh.pa.us
Whole thread Raw
In response to What db objects can only be created with superuser?  (Yash Jain <jainism987e@gmail.com>)
List pgsql-hackers
Tree view 
Yash Jain <jainism987e@gmail.com> writes:
> I understand that the C-based functions can only be created by a superuser.
> Are there any other db objects that require superuser? Or is C-based
> functions the only one?

Scalar types and operator classes are two, there are probably others
I'm not thinking of.  Search the CREATE reference pages for mentions
of "superuser".

            regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: doc fail about ALTER TABLE ATTACH re. NO INHERIT
Next
From: Tom Lane
Date:
Subject: Re: Misleading "epoll_create1 failed: Too many open files"