Re: SYSTEM_USER reserved word implementation - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: SYSTEM_USER reserved word implementation
Date
Msg-id CAAWbhmgLnMTrC6DcS2b_xNOAZCCoHzV4Y95dYPnow19idgFemQ@mail.gmail.com
Whole thread Raw
In response to Re: SYSTEM_USER reserved word implementation  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
On Wed, Jun 22, 2022 at 9:26 AM Joe Conway <mail@joeconway.com> wrote:
> On 6/22/22 11:35, Jacob Champion wrote:
> > On Wed, Jun 22, 2022 at 8:10 AM Joe Conway <mail@joeconway.com> wrote:
> Why would you want to do it differently than
> SessionUserId/OuterUserId/CurrentUserId? It is analogous, no?

Like I said, now there are two different sources of truth, and
additional code to sync the two, and two different APIs to set what
should be a single write-once attribute. But if SystemUser is instead
derived from authn_id, like what's just been proposed with
`method:authn_id`, I think there's a better argument for separating
the two.

--Jacob



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: SYSTEM_USER reserved word implementation
Next
From: "David G. Johnston"
Date:
Subject: Re: SYSTEM_USER reserved word implementation