Re: Sql.pgsql behavior in case of errors

2014-08-21 Thread Stephen R. van den Berg
Stephen R. van den Berg wrote: >aldem-pike...@aldem.net wrote: >>I am preparing to use Postgres in my app, found the following strange >>behavior: >>---snip--- >>Sql.Sql db = Sql.Sql("pgsql://localhost", "test", "test", "test"); >>db->query("BEGIN"); >>db->query("INSERT INTO requests (Sv

Re: Sql.pgsql behavior in case of errors

2014-08-20 Thread Stephen R. van den Berg
aldem-pike...@aldem.net wrote: >I am preparing to use Postgres in my app, found the following strange behavior: >---snip--- >Sql.Sql db = Sql.Sql("pgsql://localhost", "test", "test", "test"); >db->query("BEGIN"); >db->query("INSERT INTO requests (SvTrId) VALUES ('lala')"); >catch(db->quer

Re: Sql.pgsql behavior in case of errors

2011-03-28 Thread Marcus Agehall (nu med K-m�rkt fastighet och ny elcentral) @ Pike (-) developers forum
Now, I'm not a Postgres user, so I might be totally wrong here, but I know I got bitten by the autocommit in MySQL once. There isn't anything similar at work here?

Re: Sql.pgsql behavior in case of errors

2011-03-27 Thread aldem-pikedev
On Sun, Mar 27, 2011 at 03:10:02PM +, Martin Stjernholm, Roxen IS @ Pike developers forum wrote: > What people are using Postgres? I don't know who would look into this > now when (apparently) srb has left the pike crowd. Well, I need it - as I've old app which is still in heavy use, but

Re: Sql.pgsql behavior in case of errors

2011-03-27 Thread Lance Dillon
I use postgres, but I don't do a lot of testing of it yet. - Original Message > From: "Martin Stjernholm, Roxen IS @ Pike developers forum" ><10...@lyskom.lysator.liu.se> > To: pike-devel@lists.lysator.liu.se > Sent: Sun, March 27, 2011 11:10:02 AM

Sql.pgsql behavior in case of errors

2011-03-27 Thread Martin Stjernholm, Roxen IS @ Pike developers forum
What people are using Postgres? I don't know who would look into this now when (apparently) srb has left the pike crowd. But I agree that a failed statement shouldn't necessarily imply a rollback. Have you checked what the old postgres glue does?

Sql.pgsql behavior in case of errors

2011-03-24 Thread aldem-pikedev
Hi everyone, I am preparing to use Postgres in my app, found the following strange behavior: ---snip--- Sql.Sql db = Sql.Sql("pgsql://localhost", "test", "test", "test"); db->query("BEGIN"); db->query("INSERT INTO requests (SvTrId) VALUES ('lala')"); catch(db->query("INSERT INTO requests