Re: What db objects can only be created with superuser?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yash Jain <jainism987e(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: What db objects can only be created with superuser?
Date: 2024-11-26 16:15:56
Message-ID: 1679716.1732637756@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Yash Jain <jainism987e(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2024-11-26 16:23:11 Re: On non-Windows, hard depend on uselocale(3)
Previous Message Alvaro Herrera 2024-11-26 15:53:26 Re: doc fail about ALTER TABLE ATTACH re. NO INHERIT