Re: STL problem in stored procedures

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: STL problem in stored procedures
Дата
Msg-id 1163.1130296697@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: STL problem in stored procedures  (Andreas Seltenreich <seltenreich@gmx.de>)
Список pgsql-general
Andreas Seltenreich <seltenreich@gmx.de> writes:
> Tom Lane schrob:
>> And on top of that, what if the error was one that the backend can't
>> recover from except by a transaction abort? If some level of the C++
>> code thinks it can catch and recover from the error, you've left
>> things in a pretty bad state.

> Hmm, but if you replace "C++" with "C" and "catch" with "PG_TRY" in
> that sentence, wouldn't that be business as usual?

Sure, but one hopes that someone writing PG_TRY is clued-in enough to
consider this issue.  The thing that is worrying me here is that generic
STL code written by someone who never heard of Postgres is going to try
to make decisions about whether it can recover from an error thrown by
some part of the backend.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Map of Postgresql Users (OT)
Следующее
От: "surabhi.ahuja"
Дата:
Сообщение: Re: a stored procedure ..with integer as the parameter