BUG #16048: SQLSTATE 22P05 is not captured in exception clause

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16048: SQLSTATE 22P05 is not captured in exception clause
Дата
Msg-id 16048-ff86833b63f1a0a2@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16048: SQLSTATE 22P05 is not captured in exception clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      16048
Logged by:          Fabio Henrique Gibon
Email address:      fabiogibon@gmail.com
PostgreSQL version: 12.0
Operating system:   Windows
Description:

Hi,
 
        I have a database using LATIN1 (and I can't change it), so, when the
user informar a invalid character it is not captured in exception clause.
See a short sample:

DO $$
DECLARE 
   v varchar;

BEGIN

   v := 'ABCŸ';

EXCEPTION

WHEN others THEN
RAISE INFO 'Error State: %', SQLSTATE;

END$$;


I tried in old versions (9.0, 9.6,...) and the result is the same. The error
is propagated, disregarding the exception treatement.

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16049: log_line_prefix=%a and log_connections - application_name missing