Re: PL/PgSQL: RAISE and the number of parameters

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PL/PgSQL: RAISE and the number of parameters
Дата
Msg-id CAFj8pRCX0TXt8Q7n1Q+cxtJ9WtjTEHFZ5pKOXT7O-SRDQCctdA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PL/PgSQL: RAISE and the number of parameters  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
Дерево обсуждения



2014-08-12 19:14 GMT+02:00 Fabien COELHO <coelho@cri.ensmp.fr>:

one note: this patch can enforce a compatibility issues - a partially broken functions, where some badly written RAISE statements was executed newer.

I am not against this patch, but it should be in extra check probably ??

I'm not sure about what you mean by "it should be in extra check".

Or we have to documented it as potential compatibility issue.

Indeed, as a potential execution error is turned into a certain compilation error.

If this compatibility point is a blocker, the compilation error can be turned into a warning, but I would prefer to keep it an error: I'm quite sure I fell into that pit at least once or twice.

I prefer error, although there is possibility to control a force of exception - error or warning via extra plpgsql checks - this kind of error is strange - and stored procedures usually can be fixed later because plpgsql source is available.

There was a precedent with more precious query syntax check more times. Just it should be well documented.

Regards

Pavel


 

--
Fabien.

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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Hokey wrong versions of libpq in apt.postgresql.org
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Supporting Windows SChannel as OpenSSL replacement