MIME-Version: 1.0
In-Reply-To: <9C5DD0F7-B421-488E-BD41-C90287081D6A.1@smtp-inbound1.duck.com>
References: <9C5DD0F7-B421-488E-BD41-C90287081D6A.1@smtp-inbound1.duck.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 4 Sep 2024 06:15:12 -0700
Message-ID: 
 <CAKFQuwbA+AXMZjALTAkRXviHEEE7bQsRtLaErTaSkY+Zm3RmEA@mail.gmail.com>
Subject: Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
To: "keypey@duck.com" <keypey@duck.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000de3fd306214af620"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbA%2BAXMZjALTAkRXviHEEE7bQsRtLaErTaSkY%2BZm3RmEA%40mail.gmail.com>
Precedence: bulk

--000000000000de3fd306214af620
Content-Type: text/plain; charset="UTF-8"

On Wednesday, September 4, 2024, <keypey@duck.com> wrote:

>
> _user := 'postgres'::name;
> end if;
>
> SET SESSION AUTHORIZATION _user::name;
> end;
> $body$
> ;
> ```
> ---
> Unfortunately, I don't know how to convert it so that SET SESSION
> AUTHORIZATION works properly.
>
>
Dynamic SQL, I.e., the execute statement.

David J.

--000000000000de3fd306214af620
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, September 4, 2024,  &lt;<a href=3D"mailto:keypey@duck.com">ke=
ypey@duck.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"=
margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div di=
r=3D"ltr"><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmai=
l_signature"><div dir=3D"ltr"><p style=3D"margin:0px"><br>_user :=3D &#39;p=
ostgres&#39;::name;<br>end if;<br><br>SET SESSION AUTHORIZATION _user::name=
;<br>end;<br>$body$<br>;<br>```<br>---<br>Unfortunately, I don&#39;t know h=
ow to convert it so that SET SESSION AUTHORIZATION works properly.<br><br><=
/p></div></div></div></div></blockquote><div><br></div><div>Dynamic SQL, I.=
e., the execute statement.</div><div><br></div><div>David J.=C2=A0</div>

--000000000000de3fd306214af620--