6 messages in org.postgresql.pgsql-jdbcRe: Using ON_ERROR_ROLLBACK functiona...
FromSent OnAttachments
Koth, Christian (DWBI)Jul 28, 2006 1:39 am 
Kris JurkaJul 28, 2006 1:56 am 
Koth, Christian (DWBI)Jul 28, 2006 2:50 am 
Mark LewisJul 28, 2006 8:57 am 
Kris JurkaJul 28, 2006 9:17 am 
Kris JurkaJul 28, 2006 9:23 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: Using ON_ERROR_ROLLBACK functionality in JDBCActions...
From:Kris Jurka (boo@ejurka.com)
Date:Jul 28, 2006 9:23:33 am
List:org.postgresql.pgsql-jdbc

On Fri, 28 Jul 2006, Mark Lewis wrote:

Does the current savepoint implementation in the driver require a separate round-trip?

Yes. Creating, rolling back to, or releasing a savepoint each currently make a server round-trip. If you're suggesting queueing these up so that it sends these with queries instead of alone, I think that's something the driver could do if it was creating savepoints itself, but would be tougher to do for user savepoints. For user savepoints I think you need to get feedback to the caller immediately upon command execution rather than with a later query. Consider something like trying to release an invalid savepoint. You need to tell the user immediately.