Re: Procedure support improvements - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Procedure support improvements
Date
Msg-id CADK3HH+Bfat=byMsatf9VZ2VcG7Geu7=QJBSbJ8cTeE=sqtkAw@mail.gmail.com
Whole thread Raw
In response to Re: Procedure support improvements  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Procedure support improvements  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Procedure support improvements  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Procedure support improvements  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-jdbc


On Mon, 26 Aug 2019 at 13:43, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
Dave Cramer wrote:
> As I said, I'd entertain a connection parameter that switched the
> CALL to call procedures but ideally you'd complain to the server
> folks to make Procedures useful.

Apart from the obvious problem that procedures make life hard for the
JDBC driver, because it does not know if it shall render a call as
SELECT or CALL:
What is missing in PostgreSQL procedures to make them useful?

being able to use transactions inside a procedure inside a transaction.


 

Yours,
Laurenz Albe

pgsql-jdbc by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Procedure support improvements
Next
From: Laurenz Albe
Date:
Subject: Re: Procedure support improvements