Re: Error on failed COMMIT
От | Dave Cramer |
---|---|
Тема | Re: Error on failed COMMIT |
Дата | |
Msg-id | CADK3HHLuorK_Dx2QFD_o0RXa2oBkx2uOmOx3GH0NnURT_xk9Cw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Error on failed COMMIT (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: Error on failed COMMIT
|
Список | pgsql-hackers |
On Tue, 17 Mar 2020 at 19:23, Bruce Momjian <bruce@momjian.us> wrote:
On Tue, Mar 17, 2020 at 07:15:05PM -0400, Dave Cramer wrote:
> On Tue, 17 Mar 2020 at 16:47, Bruce Momjian <bruce@momjian.us> wrote:
> Third, the idea that individual interfaces, e.g. JDBC, should throw an
> error in this case while the server just changes the COMMIT return tag
> to ROLLBACK is confusing. People regularly test SQL commands in the
> server before writing applications or while debugging, and a behavior
> mismatch would cause confusion.
>
>
> I'm not sure what you mean by this. The server would throw an error.
I am saying it is not wise to have interfaces behaving differently than
the server, for the reasons stated above.
Agreed and this is why I think it is important for the server to be defining the behaviour instead of each interface deciding how to handle this situation.
Dave Cramer
www.postgres.rocks
В списке pgsql-hackers по дате отправления: