Re: Bytea PL/Perl transform

2023-07-20 Thread Ivan Panchenko
>Friday, 14 July 2023, 23:27 +03:00 от Tom Lane : >  >=?UTF-8?B?SXZhbiBQYW5jaGVua28=?= < w...@mail.ru > writes: >> Четверг, 6 июля 2023, 14:48 +03:00 от Peter Eisentraut < >> pe...@eisentraut.org >: >>> If the transform deals with a built-in type, then they should just be >>> added to the

Re: Bytea PL/Perl transform

2023-07-14 Thread Ivan Panchenko
>Четверг, 6 июля 2023, 14:48 +03:00 от Peter Eisentraut < pe...@eisentraut.org >>: >  >On 22.06.23 22:56, Greg Sabino Mullane wrote: >> * Do all of these transforms need to be their own contrib modules? So >> much duplicated code across contrib/*_plperl already (and *plpython too >> for that

Re[2]: On login trigger: take three

2022-03-30 Thread Ivan Panchenko
  Hi, >Tue, March 29, 2022, 0:31 +03:00 from Andres Freund : >  >Hi, > >On 2022-03-28 23:27:56 +0200, Daniel Gustafsson wrote: >> > On 28 Mar 2022, at 19:10, Andres Freund < and...@anarazel.de > wrote: >> > On 2022-03-28 15:57:37 +0300, a.soko...@postgrespro.ru wrote: >> >> >> + data

Re[2]: On login trigger: take three

2021-11-03 Thread Ivan Panchenko
Oracle (in the worst sense). I do not like this. A new version of the patch is attached. It applies to the current master and contains the above mentioned GUC code, relevant tests and docs. Regards, Ivan Panchenko > >On 15.09.2021 16:32, Greg Nancarrow wrote: >> On Wed, Sep 8, 2021 at

Re[5]: On login trigger: take three

2021-08-16 Thread Ivan Panchenko
insist on empty stderr as well as a stdout >match"). >So I had to remove a "RAISE NOTICE" (which was just an informational >message) from the login trigger function, to satisfy the new >poll_query_until expectations. Does it mean that "RAISE NOTICE" should’t be

Re[3]: On login trigger: take three

2021-05-19 Thread Ivan Panchenko
Hi, I have upgraded the patch for the 14th version. >Вторник, 16 марта 2021, 14:32 +03:00 от Ivan Panchenko : >  >Hi, > >Thank you, Konstantin, for this very good feature with numerous use cases. >Please find the modified patch attached. > >I’ve added the ‘enable_client

Re[2]: On login trigger: take three

2021-03-16 Thread Ivan Panchenko
Hi, Thank you, Konstantin, for this very good feature with numerous use cases. Please find the modified patch attached. I’ve added the ‘enable_client_connection_trigger’ GUC to the sample config file and also an additional example page to the docs. Check world has passed and it is ready for

Re[6]: bool_plperl transform

2020-03-07 Thread Ivan Panchenko
Tom,   >Суббота, 7 марта 2020, 1:15 +03:00 от Tom Lane : >  >=?UTF-8?B?SXZhbiBQYW5jaGVua28=?= < w...@mail.ru > writes: >> [ bool_plperl_transform_v3.patch ] >I reviewed this, fixed some minor problems (mostly cosmetic, but not >entirely), and pushed it. Thanks for the commit and for your work

Re[4]: bool_plperl transform

2020-03-01 Thread Ivan Panchenko
Thanks, Tom.   I think now it should build, please find the fixed patch attached. I had no possibility to check it on Windows now, but the relevant changes in Mkvcbuild.pm are done, so I hope it should work. The documentation changes are also included in the same patch.   Regards, Ivan  

Re[2]: bool_plperl transform

2020-03-01 Thread Ivan Panchenko
  >Понедельник, 2 марта 2020, 1:09 +03:00 от ilm...@ilmari.org: >  >Wao < w...@mail.ru > writes: >  >> +Datum >> +bool_to_plperl(PG_FUNCTION_ARGS) >> +{ >> + dTHX; >> + bool in = PG_GETARG_BOOL(0); >> + SV *sv = newSVnv(SvNV(in ? _sv_yes : _sv_no)); >> + return PointerGetDatum(sv); >> +} >Why

Re[2]: bool_plperl transform

2020-03-01 Thread Ivan Panchenko
  >Воскресенье, 1 февраля 2020, 1:15 +03:00 от Tom Lane : >  >=?UTF-8?B?SXZhbiBQYW5jaGVua28=?= < w...@mail.ru > writes: >> While using PL/Perl I have found that it obtains boolean arguments from >> Postgres as ‘t’ and ‘f’, which is extremely inconvenient because ‘f’ is not >> false from the

bool_plperl transform

2020-02-29 Thread Ivan Panchenko
. This is very simple, a patch is attached. Also this patch improves the plperl documentation page, which now has nothing said about the transforms.   Regards, Ivan Panchenko     bool_plperl_transform_v1.patch Description: Binary data

Re[2]: jsonb_plperl bug

2019-08-03 Thread Ivan Panchenko
> Tom Lane : > >=?UTF-8?B?SXZhbiBQYW5jaGVua28=?= < w...@mail.ru > writes: >> I have found a bug in jsonb_plperl extension. A possible fix is proposed >> below. >> ... >> +/* SVt_PV without POK flag is also NULL */ >> +if(SvTYPE(in) ==

jsonb_plperl bug

2019-08-02 Thread Ivan Panchenko
Hi, I have found a bug in jsonb_plperl extension. A possible fix is proposed below. jsonb_perl is the contrib module, which defines TRANSFORM functions for jsonb data type and PL/Perl procedural language. The bug can be reproduced as follows: CREATE EXTENSION plperl; CREATE EXTENSION