TPQConnection connection handling
Original Reporter info from Mantis: desmondc
-
Reporter name: Desmond C
Original Reporter info from Mantis: desmondc
- Reporter name: Desmond C
Description:
When doing TPQConnection.Connected := True, one connection is spawned on the pgsql srv. When executing a select query with TSQLQuery.Open, the action will spawn another connection on the pgsql srv where the query is exec'ed.
How come?
Can this be changed that all queries go through the same pgconnection object?
Steps to reproduce:
On a Linux pgsql srv, set up " watch -n 0.1 'ps -ef | grep postgres | grep -v "grep"' "
In application, setup TPQConnection, then do .Connected := True
See one connection on pgsql srv.
Now setup TSQLQuery & transaction with default transaction handling with .SQL.Text := 'select current_timestamp'. Now call .Open on query
See another connection on the pgsql srv.
Mantis conversion info:
- Mantis ID: 17711
- Build: rc1
- Version: 2.4.0
- Fixed in version: 3.0.0
- Target version: 3.0.0