Re: Check constraint on domain over an array not executed for array literals

Поиск
Список
Период
Сортировка
От Florian G. Pflug
Тема Re: Check constraint on domain over an array not executed for array literals
Дата
Msg-id 4AFD7F58.3040406@phlo.org
обсуждение исходный текст
Ответ на Re: Check constraint on domain over an array not executed for array literals  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Check constraint on domain over an array not executed for array literals
Список pgsql-hackers
Heikki Linnakangas wrote:
> Agreed, it's a bug. A simpler example is just: [snipped]

Will this fix for this be included in 8.4.2 (or .3), or will it have to
wait for 8.4 because it changes behavior?

> There's a special case in transformExpr function to handle the 
> "ARRAY[...]::arraytype" construct, which skips the usual type-casting
>  and just constructs an ArrayExpr with the right target type.
> However, it's not taking into account that the target type can be a
> domain.
> 
> Attached patch fixes that. Anyone see a problem with it?
I'm not familiar with the parser so I can't really judge this. However,
I've applied the patch to my development db and it seems to work fine,
and fixes the bug.

Thanks for the quick response!

best regards,
Florian Pflug

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Aggregate ORDER BY patch
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: PL/Python array support