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: > > could not receive data from client: Connection reset by peer > unexpected EOF on client connection with an open transaction > > I'm using TPQConnection/TSqlTransaction/TSqlQuery in a CGI with this method: > > procedure TDataModule1.ExecSql(ASql: string); > var > lSql: TSQLQuery; > begin > lSql := TSQLQuery.Create(nil); > try > lSql.DataBase := PQConnection1; > lSql.Transaction := SQLTransaction1; > lSql.SQL.Text:= ASql; > lSql.ExecSQL; > SQLTransaction1.Commit;
Only guessing: maybe the transaction object is set to "autocommit" and the .Commit statement produces the error? Marc > finally > lSql.Free; > end; > end; > > The query is executed without issues, data is stored into the db, but I > keep getting those messages. > > I'm using FPC 3.1.1 - Lazarus 1.5 - Linux 64bits (Ubuntu 15.04). > > Regards, -- Marc Santhoff <m.santh...@web.de> -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus