[Lazarus] What is a TSQLTransaction and why do I need one?

[Martin Schreiber]

On Thursday, 25. November 2010 09.37:05 Mark Morgan Lloyd wrote:
> Martin Schreiber wrote:
> > Firebird has the ability for 'named transactions'. It is possible to run
> > multiple transactions in parallel on a single connection. PostgreSQL does
> > not offer this possibility. In PQ there is for every transaction a
> > separate connection and even an additional server process AFAIK!
>
> It was the multiplicity of handles- a long-term one for the connection
> object and short-term ones for transaction objects- that gave me
> problems with listen/notify.
>
MSEgui uses the handle of the connection component for the first PQ 
transaction. Additional connections are opened if parallel transactions are 
started. I don't know if the original FPC sqldb works the same.

Martin