Achilleas Mantzios

Same issue here, casting problem but strangely for postgresql column : `select qry.* FROM (select d."TRNS_DATE"::date as "TRNS_DATE",d."PARAST" as "DOC_NO",CASE WHEN dtls."ID" IS NOT NULL THEN 'REM' ELSE 'CHQ' END...

as it seems only option is to continue using the python2 packages, e.g. by adding to /etc/apt/sources.list : deb http://cz.archive.ubuntu.com/ubuntu eoan main universe and then install wxbanker by hand (git...

So we got like year 2020 AD approaching, PostgreSQL 12 due to be released this month, and still no LDAP FDW extension.

I know, I have been using it (pgsql) since 2000. Anyways, I recall when I had installed it (ldap_fdw) it worked nice. Its a pity it doesn't compile for >=11....

I dont see bms_is_empty in my pgsql16 installation : postgres@smadb:$ nm /usr/local/pgsql/lib/tds_fdw.so | grep bms_ U bms_del_member U bms_equal U bms_is_member U bms_make_singleton U bms_union postgres@smadb:$ whereas this exists in...

Hello we had the same behavior on latest pgsqp16 and latest jdbc 42.7.3 . Our array (column called work) is smallint[] . The code does : Array work = rswork.getArray(1);...

@davecramer thank you, I know I am not testing via the protocol but via SQL, but I suspect this is the same : ``` amantzio@[local]/dynacom=# CREATE FUNCTION public.sum(i1 int, i2...

How does it work correctly from psql ? Besides if we revert the patch , the search_path with pgbouncer in transaction pooling with search_path-based multitenancy will be broken anyway. However...

Thank you, there is obviously something we (me and my colleagues) are missing. We will be back!

Hello, I recompiled postgresql without the search_path guc patch, here is my test : **test_prepared_stmts_search_path_no_pg_guc_patch.java** ` import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.PreparedStatement; import java.sql.Statement; import java.sql.ResultSet; public class...