Re: BUG #16242: convert_tuple_* not handling missing values correctly

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: BUG #16242: convert_tuple_* not handling missing values correctly
Дата
Msg-id 31edb400-f065-73c4-7b1f-2953ad3413e6@postgresfriends.org
обсуждение исходный текст
Ответ на BUG #16242: convert_tuple_* not handling missing values correctly  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16242: convert_tuple_* not handling missing values correctly  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
On 04/02/2020 03:24, PG Bug reporting form wrote:
> The following example shows a tuple appearing with NULLs in a column
> declared NOT NULL, because there is a missing default value not being filled
> in. The cause is that convert_tuples_by_name, or more precisely
> check_attrmap_match, thinks that it's enough for the tupdescs to match up as
> regards attnums/names/types, without considering that the source tupdesc
> might have missing values that the destination does not. So it incorrectly
> concludes that no conversion is needed, and the missing values become
> null.

Here is a quick patch that fixes this on master.
-- 
Vik Fearing

Вложения

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

Предыдущее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: FK violation in partitioned table after truncating a referencedpartition
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #16242: convert_tuple_* not handling missing values correctly