Zeoslib Portal

for me it seems that the problem is that you need to make sure, that updated in the database doesn't overlap. If you can get to that point, you can easily have one connection per thread: Yes, I have no overlaps, and I use 1 connection in each DB thread. As long, as the threads that parse the data d...

Hello! Jan , I have no problems with multi threading and locks in the database. I just shared my approach with aehimself . In fact, I have 400 incoming info flows, each flow is placed in some separated tables. I have data Intersection only on a level of reference tables and tables with processing ta...

Hellow! marsupilami, The introduction of procedures in PG11 is to enable the use of internal transactions that have not been addressed in previous versions of PG. https://www.postgresql.org/docs/11/plpgsql-transactions.html Therefore, with the work of the procedures must be ensured. This need will g...

Hi! I tried to use 1 TZConnection for different TZReadOnlyQuery in different threads. As a result, I got Access Violation in case the threads are accessing at the same time. So I can not call a thread-protected ZConnection. But that was before the advent of ZEOS 7.2.4. Exactly the version on which I...

Hi everyone! First of all thanks to Zeos developers for a cool free product! Faced a problem of a call of the Postgres 11 procedure. select VERSION(); PostgreSQL 11.1, compiled by Visual C++ build 1914, 64-bit Example: CREATE OR REPLACE PROCEDURE "testuser"."testproc"(IN "x&...