On Tue, 2006-04-18 at 14:27 -0700, johnf wrote: > On Tuesday 18 April 2006 13:42, Marc Santhoff wrote: > > Am Dienstag, den 18.04.2006, 21:29 +0200 schrieb Joost van der Sluis: > > > On Tue, 2006-04-18 at 14:43 -0400, Alexandre Leclerc wrote: > > > > 2006/4/18, Joost van der Sluis <[EMAIL PROTECTED]>: > > > > > But you can have one connection, whith several transactions bound > > > > > > to it. > > > > > > > > PostgreSQL doesn't support that, but SQLdb handles that for you, > > > > > > it > > > > > > > > creates new connection internally automatically. > > > > > > > > Do you mean TPQConnection does not support many TSQLTransaction? > > > > > > 'But you can have one connection, whith several transactions bound to > > > it.' > > > > > > So you can. > > > > > > Only PostgreSQL can't, so SQLDdb handles it. > > > > May I ask: > > > > Is this a problem with PostrgreSQL itself or the component in lazarus > > wrapping it? > > > > I'm planning to use PG in the near future, but this may influence my > > decision ... > > > > TIA, > > Marc > > I can't answer your question directly. But I can provide a little > information > about what I have added to this discussion. First let me say that I have > always used only one connection to a database engine and controlled all of my > transactions in code in the past (just to let you know where I'm coming > from). But with FPC I was not able to use just one connection to the > database.
There's a difference between 'FPC can't' and 'PostgreSQL can't' Since FPC can do this, but postgresql can't. So sqldb hides the creation of a second connection to the database. If that doesn't work, it's a bug. But in the case of postgres you should not think of connections. In reality, it has no connections, it only has transactions! You open a transaction to the database... -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives