pgsql: plpgsql's exec_simple_cast_value() mistakenly supposed that it

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: plpgsql's exec_simple_cast_value() mistakenly supposed that it
Дата
Msg-id 20090402011611.8A8D6754ADE@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
plpgsql's exec_simple_cast_value() mistakenly supposed that it could bypass
casting effort whenever the input value was NULL.  However this prevents
application of not-null domain constraints in the cases that use this
function, as illustrated in bug #4741.  Since this function isn't meant
for use in performance-critical paths anyway, this certainly seems like
another case of "premature optimization is the root of all evil".

Back-patch as far as 8.2; older versions made no effort to enforce
domain constraints here anyway.

Modified Files:
--------------
    pgsql/src/pl/plpgsql/src:
        pl_exec.c (r1.236 -> r1.237)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c?r1=1.236&r2=1.237)

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

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Improve pg_dump's query for retrieving BLOB comments to be more
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: plpgsql's exec_simple_cast_value() mistakenly supposed that it