Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Leonardo M . Ramé
Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. No, just a TSQLTransaction attached to the TPQConnection object. I commented all my code but the PQConnection1.Connected := True, and I noted I get the "could not receive data from

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Michael Van Canneyt
On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. No, just a TSQLTransaction attached to the TPQConnection object. I commented all my code but the PQConnection1.Connected := True, and I

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 16:11, Leonardo M. Ramé escribió: El 02/09/15 a las 16:00, Michael Van Canneyt escribió: Well, that is why I asked how it is closed. Maybe it was closed a different way in your CGI, without properly closing it. The strange thing is that it reports an active transaction. Do

[Lazarus] fpGUI Toolkit v1.4.1 released

2015-09-02 Thread Graeme Geldenhuys
Hi, I'm glad to announce the v1.4.1 maintenance release of fpGUI. I'll shortly update the file and documentation downloads on SourceForge. Source Code: from SourceForge: git clone git://git.code.sf.net/p/fpgui/code fpgui from GitHub: git clone

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 15:09, Michael Van Canneyt escribió: On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. Yes, I added an onDestroy event to the datamodule containing the PQConnection

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Michael Van Canneyt
On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: El 02/09/15 a las 15:09, Michael Van Canneyt escribió: On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. Yes, I added an onDestroy event

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 16:00, Michael Van Canneyt escribió: Well, that is why I asked how it is closed. Maybe it was closed a different way in your CGI, without properly closing it. The strange thing is that it reports an active transaction. Do you open a dataset ? If so, try setting

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Marc Santhoff
On Di, 2015-09-01 at 14:26 -0300, Leonardo M. Ramé wrote: > Hi, this is kind of a dejavu, I'm pretty sure I have asked this question > before, but I can't find the old message, so, here I go. > > In my postgresql.log file I get this two messages every time I > query/update the database: > >

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Michael Van Canneyt
On Tue, 1 Sep 2015, Leonardo M. Ramé wrote: Hi, this is kind of a dejavu, I'm pretty sure I have asked this question before, but I can't find the old message, so, here I go. In my postgresql.log file I get this two messages every time I query/update the database: could not receive data

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Mark Morgan Lloyd
Marc Santhoff wrote: On Di, 2015-09-01 at 14:26 -0300, Leonardo M. Ramé wrote: Hi, this is kind of a dejavu, I'm pretty sure I have asked this question before, but I can't find the old message, so, here I go. In my postgresql.log file I get this two messages every time I query/update the

Re: [Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 10:28, Marc Santhoff escribió: Only guessing: maybe the transaction object is set to "autocommit" and the .Commit statement produces the error? It's configured to caRollBack. -- ___ Lazarus mailing list