Re: [PoC] Federated Authn/z with OAUTHBEARER

2025-04-22 Thread Ivan Kush
end to authorize tokens issued by Google? Last I checked, they still had no way to register an application-specific scope, making it very dangerous IMO to use a public flow [2]. I've also thought as Antonin about https://www.googleapis.com/oauth2/v3/userinfo for verification As I understand from [2], the current problem is security, Google doesn't want to add new scopes. -- Best wishes, Ivan Kush Tantor Labs LLC

Re: [PoC] Federated Authn/z with OAUTHBEARER

2025-04-20 Thread Ivan Kush
h_scheme: body     },     {     issuer: someservice         add_err_code: [403],         auth_scheme: basic     } ] -- Best wishes, Ivan Kush Tantor Labs LLC

Re: pg_stat_statements: improve loading and saving routines for the dump file

2025-01-21 Thread Ivan Kush
p file and set to zero and the irrelevant dump file is skipped. This is the actual behaviour implemented in the code. Respectfully, Mikhail Litsarev, Postgres Professional: https://postgrespro.com -- Best wishes, Ivan Kush Tantor Labs LLC

Re: pg_stat_statements: improve loading and saving routines for the dump file

2025-01-20 Thread Ivan Kush
re written/read with its last field slock_t    mutex; which is actually not used then. This small patch fixes this issue. Hope, it will be useful. Respectfully, Mikhail Litsarev, Postgres Professional: https://postgrespro.com -- Best wishes, Ivan Kush Tantor Labs LLC

Re: Replace IN VALUES with ANY in WHERE clauses during optimization

2024-11-11 Thread Ivan Kush
l.org/message-id/21d5fca5-0c02-4afd-8c98-d0930b298a8d%40gmail.com -- Best wishes, Ivan Kush Tantor Labs LLC

Re: Replace IN VALUES with ANY in WHERE clauses during optimization

2024-10-04 Thread Ivan Kush
Some ORMs or proprietary software may write it mistakenly. In these cases this idea may be helpful. This patch contains GUC to enable/disable this optimization On 10/3/24 23:19, Laurenz Albe wrote: On Thu, 2024-10-03 at 23:10 +0300, Alena Rybakina wrote: On 03.10.2024 22:52, Ivan Kush wrote

Re: Replace IN VALUES with ANY in WHERE clauses during optimization

2024-10-04 Thread Ivan Kush
PLAN ---  Seq Scan on t (actual rows=1 loops=1)    Filter: (x = ANY ('{1200,1}'::integer[])) (3 rows) -- Best wishes, Ivan Kush Tantor Labs LLC

Replace IN VALUES with ANY in WHERE clauses during optimization

2024-10-03 Thread Ivan Kush
ed in Postgres) # Authors. Author: Ivan Kush Author: Vadim Yacenko Author: Alexander Simonov # Tests Implementation contains many regression tests of varying complexity, which check supported features. # Platform This patch was checkouted from tag REL_17_STABLE. Code is developed in

Re: Autonomous transactions 2023, WIP

2024-01-01 Thread Ivan Kush
lity to load log file to the database: * detect file size, * load to database * autorotate file by timeout of filesize * etc. Some of our customers use "Autonomous transactions" for logging =) -- Best wishes, Ivan Kush Tantor Labs LLC

Re: Autonomous transactions 2023, WIP

2023-12-31 Thread Ivan Kush
n of global > variables. It can be common with autonomous transactions. > > Surely, the first topic should be the method of implementation. Maybe > I missed it, but there is no agreement of background worker based. > > Regards > > Pavel > > -- Best wishes, Ivan Kush Tantor Labs LLC -- Best wishes, Ivan Kush Tantor Labs LLC

Re: Autonomous transactions 2023, WIP

2023-12-24 Thread Ivan Kush
tbl VALUES (1);   END; END; ``` https://firebirdsql.org/refdocs/langrefupd25-psql-autonomous-trans.html On 21.12.2023 14:26, Andrey M. Borodin wrote: On 15 Dec 2023, at 16:28, Ivan Kush wrote: Hello. I'm working on the support of autonomous transactions in Postgres. # Summary * Ad

Re: Autonomous transactions 2023, WIP

2023-12-24 Thread Ivan Kush
to support threads in Postgres. One significant part of this project is elimination of global variables. It can be common with autonomous transactions. Surely, the first topic should be the method of implementation. Maybe I missed it, but there is no agreement of background worker based. Regards Pavel -- Best wishes, Ivan Kush Tantor Labs LLC