Horton

Re: security_definer_search_path GUC

Joel Jacobson <joel@compiler.org>

View thread
From: "Joel Jacobson" <joel@compiler.org>
To: pgsql-hackers@lists.postgresql.org, "Marko Tiikkaja" <marko@joh.to>
Date: 2021-05-30T07:30:15Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Create a new GUC variable search_path to control the namespace search

On Sun, May 30, 2021, at 08:51, Joel Jacobson wrote:
> Maybe this is out of scope for extensions, since I guess extensions are supposed to add features?
> 
> If so, how about a new separate command `CREATE REDUCTION` specifically to remove unwanted core features,
> which then wouldn't need the "no_" prefix since it would be implicit and in a different namespace:

Another idea would be to extract features that are considered deprecated/legacy into separate extensions,
and ship them pre-installed for compatibility reasons,
but this would allow uninstalling them using DROP EXTENSION,
similar to how e.g. "plpgsql" which is a pre-installed extension can be uninstalled.

(Except I wouldn't want to uninstall plpgsql, I think it's great! But I note it's the only pre-installed extension shipped with PostgreSQL, so it's a good example on the concept.)

/Joel