On Tue, 2006-04-18 at 22:42 +0200, 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?
It's a problem of postgres. A transaction 'block' is started with the
sql-command 'begin', from that comand on, all queries are executed
within that transaction. Using another connection is not possible.
Unless, offcourse, you start a new connection. Or closes the transaction
(commit, rollback etc)
JoJo,
Joost.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
