[postgres] INSERT and SELECT in one request doesn't work properly about jdbi

[stevenschlansker]

Hi @Mario-Eis , I think this is not a bug. The JDBC api does not guarantee that you can execute multiple SQL statements in one JDBC Statement with a ; - supporting that would be on a vendor-by-vendor basis.

In order to execute multiple statements in a cross-db compatible way, you would use either the Batch or Script api, or make multiple calls with a handle.inTransaction(txn -> txn.createUpdate("INSERT ...").execute(); txn.createQuery("SELECT ...").one())

Hope that helps.

[Mario-Eis]

Oh, I see. The intention to do it in one go was to save access time. I was used to it from MsSQL Server.
Thanks for the information.

It also doesn't work with WITH INSERT...SELECT. That's something I also found strange.