prepared statement "PRSTMTST929595841176" already exists

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Posts: 1
Joined: Tue 19 Jun 2018 19:30

prepared statement "PRSTMTST929595841176" already exists

Post by fabricio.sartoretto » Tue 19 Jun 2018 19:37

Hello people
I have the following error generating in my application: prepared statement "PRSTMTST929595841176" already exists

I'm using pg_pool with the devart drive config:

GetDriverFunc = getSQLDriverPostgreSQL
LibraryName = dbexppgsql40.dll
VendorLib = dbexppgsql40.dll
BlobSize = -1
HostName =
DataBase =
User_Name =
Password =
DriverAssemblyLoader = Devart.DbxPgsql.DriverLoader.TCRDynalinkDriverLoader, Devart.DbxMda.DriverLoader, Version =, Culture = neutral, PublicKeyToken = 09af7300eec23701
DriverUnit = DbxDevartPostgreSQL
ProtocolVersion = pv30

I wonder if drive is combatible with pg_pool?

Thank you to anyone who can help me.

Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: prepared statement "PRSTMTST929595841176" already exists

Post by azyk » Fri 22 Jun 2018 06:41

The specified error is generated on PostgreSQL side. Our driver gets it when requesting PostgreSQL and then returns it to the client application. Our driver does not have a possibility to control pg_pool behavior.

To avoid this error, please refer to pg_pool documentation or contact its developers.

Post Reply