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 -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
