ndto(9,
"\2\0\0\0\300\3\0\0\23\17=\7\10\0\0\0\3\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 960,
0, NULL, 0) = 960 <0.36>
sendto(9,
"\2\0\0\0\300\3\0\0\23\17=\7\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 960,
0, NULL, 0) = 960 <0.41>
***a lot of sendto***
sendto(9,
oll_wait(4,
...but it was already final.
Here are the values of the possibly involved parameters:
name | setting | unit
-+-+--
deadlock_timeout | 1000 | ms
idle_in_transaction_session_timeout | 3
re assuming the statement_timeout parameter should have worked fo that
and this is a bug?
>Вторник, 26 марта 2024, 17:43 +03:00 от Magnus Hagander :
>
>
>On Tue, Mar 26, 2024 at 3:19PM Ц < pf...@mail.ru > wrote:
>>Greetings!
>>I’ve faced with strange behavior when I see
Greetings!
I’ve faced with strange behavior when I see a lot of active sessions started
hours ago while statement_timeout = '30min'.
All of them are fetching from cursors.
Typical session looks like:
backend_start | 2024-03-26 14:34:20.552594+03
xact_start | 2024-03-26 14:34:54.974
Community, is that behavior is explainable ?
I suppose the reason of such behavior in different steps of code parsing, but
can`t find any discussions or topics in documentation.
Сould someone clarify the situation for sure?
create or replace function dbo.func(result out int ) as
Community, is that behavior is explainable ?
create or replace function dbo.func(result out int ) as $$ begin
result = 1 ; end ; $$ language plpgsql;
-- 1 --
do $$
declare
v_result int ;
begin
select p.result from dbo.func(d) p into v_result;
exception when
Thank you for clarification!
PS: Re-reading initial message, I feel ashamed for such foolish questions.
>Вторник, 14 апреля 2020, 17:04 +03:00 от Tom Lane :
>
>=?UTF-8?B?0KY=?= < pf...@mail.ru > writes:
>> create role "dot.net"
>> set session authorization 'dot.net';
>> select to_regrole(session
Hello!
I store pg_roles.oid::int as numeric representation of database role.
Now I need to get this number for session user.
I used to_regrole(session_user) function.
Everything works fine till I allow roles with dots in role`s name.
create role "dot.net"
set session authorization 'dot.net';
sel
