PostgreSQL Asynchronous Commit

[Robert DiFalco]

I have several tables that I use for login in PostgreSQL. Does jOOQ have any convenience methods that will allow me to set synchronous_commit='off' for inserts to these tables? What I want to avoid is an extra round trip to the database just to call "set synchronous_commit='off' ". 

I'm thinking my only option is to create a stored procedure for each and to set synchronous_commit='off' at the beginning of each stored procedure for these tables.

Thanks in advance!

R.

[Lukas Eder]

No, there is no such convenience in jOOQ right now. I suspect that you might be able to achieve this directly on the vendor-specific JDBC driver API? But I guess that would still create a server round-trip...

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Robert DiFalco]

No worries, I can put it into a function for now.

--
You received this message because you are subscribed to a topic in the Google Groups "jOOQ User Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jooq-user/KUNOMTRBfqA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jooq-user+...@googlegroups.com.