Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values
Дата
Msg-id CAKFQuwbtoPA5_LKd+j=Kc3XoFOaobyRgcFDfpj24jD=KFPhF6A@mail.gmail.com
обсуждение исходный текст
Ответ на Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values  (Sayyid Ali Sajjad Rizavi <sasrizavi@gmail.com>)
Ответы Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values  (Sayyid Ali Sajjad Rizavi <sasrizavi@gmail.com>)
Список pgsql-hackers
On Wednesday, January 4, 2023, Sayyid Ali Sajjad Rizavi <sasrizavi@gmail.com> wrote:

Option 1: Cast to the relevant column type in that position (to `integer` in this case), whenever we have an unknown type.

This happens when possible so any remaining cases are not possible.  Or, at least apparently not worth the effort it would take to make work.
 
Option 2: Always give error if unknown type is not casted to desired type (`null::integer` will be necessary).

Breaking working queries for this is not acceptable.

David J.

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Fix showing XID of a spectoken lock in an incorrect field of pg_locks view.
Следующее
От: Sayyid Ali Sajjad Rizavi
Дата:
Сообщение: Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values