Am Dienstag, den 18.04.2006, 23:28 +0200 schrieb Joost van der Sluis:
> 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:
> > > '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)
I see. Problems or at least unusual design approaching when regarding
datamodules ...
Thank you,
Marc
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
