Erlang/OTP Forums

Author Message

<  Erlyweb mailing list  ~  Postgresql transactions

Guest
Posted: Sun Aug 31, 2008 11:42 pm Reply with quote
Guest
Has anybody had any luck getting transactions to work with postgresql
and the erlydb_psql driver?

I am getting the same error as David King pointed out in this post:
"erlydb_psql transactions appear broken"
http://groups.google.com/group/erlyweb/browse_thread/thread/ffadbc40c392dfc6#


So, far I have some basic stuff working with erlydb, but I'm still
just learning. I'm hoping to make use of erlyweb to develop a web
interface to the postgresql database we are building. Transactions
are needed for my application.

Thanks for any help,
Michael

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post received from mailinglist
Guest
Posted: Mon Sep 01, 2008 3:23 am Reply with quote
Guest
Might have solved my own problem. At least this initial problem I was
having anyway. I can make simple transactions work now.

The problem, I think is this:
The problem was that an earlier command I was testing in the shell had
crashed. This left the connection to the database in the middle of a
transaction. If I send a erlydb_psql:q2("commit;"). or
erlydb_psql:q2("rollback;"). then it seems to put things back on
track. This would have probably also been solved by restarting the
shell and db connection.

It looks like the erlydb_psql driver is not handling errors, and
rolling back the transaction when things break in the middle.


Cheers,
Michael


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post received from mailinglist

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum