pcsoft.us.windevCopyright 2026, PC SOFT18 Apr 2020 14:11:58 Z17 Apr 2020 06:07:40 ZHi there, I'm using WD to connect to Postgres db. I noticed that each new SQLEXEC in new window always created new connection with new client port. This is strange because I called SQLCONNECT only ONCE at the beginning thus I expect WD to keep using same connection. I found out about this when I checked using PG_STAT_ACTIVITY in postgres and saw many connections from same user and app. And this has resulted in consuming the available connection in database thus reducing total number users can connect. Any chance that I can change this in WD programming to tell WD to not open new connection once SQLCONNECT is established ? Many thanks in advance for your valuable advices. Adiy30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Mygocoogspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres-67768/read.awp18 Apr 2020 14:11:58 ZHi, Thanks for the advice. I checked SQLCLOSE() but it was not the cause. Apparently the cause is the setting of Window …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres-67768/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres-67768/read.awpWhy SQLEXEC always create NEW connection in POSTGRES ?WINDEVCOLpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres-67766/read.awp17 Apr 2020 18:50:42 ZAre you using SQLClose after you finish each query ?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres-67766/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67764-why-sqlexec-always-create-new-connection-postgres-67766/read.awpWhy SQLEXEC always create NEW connection in POSTGRES ?