public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected]
To: David G. Johnston <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Date: Wed, 04 Sep 2024 09:25:30 -0400
Message-ID: <[email protected]> (raw)
References: <CAKFQuwbA+AXMZjALTAkRXviHEEE7bQsRtLaErTaSkY+Zm3RmEA@mail.gmail.com>
<[email protected]>
<[email protected]>
David
Thanks a lot!
--
kp
śr., 4 wrz 2024 o 15:15 David G. Johnston <
[email protected]> napisał(a):
> On Wednesday, September 4, 2024, wrote: _user := 'postgres'::name;end if;
> SET SESSION AUTHORIZATION _user::name;end;$body$;```---Unfortunately, I
> don't know how to convert it so that
> *DuckDuckGo* did not detect any trackers. More
> <https://duckduckgo.com/-FlJrDWmRvC6aB61K_vO3h5hJBFovO23anYwx1OQTF5ZP4Ua_XnuHMbQyiMwpRc9dlzYcsX9BjSCu...;
> Report Spam
> <https://duckduckgo.com/-FlJrDWmRvC6aB61K_vO3h5hJBFovO23anYwx1OQTF5ZP4Ua_XnuHMbQyiMwpRc9dlzYcsX9BjSCu...;
> On Wednesday, September 4, 2024, <[email protected]> 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.
>
--
kp.,
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox