Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values
Date
Msg-id CAKFQuwbtoPA5_LKd+j=Kc3XoFOaobyRgcFDfpj24jD=KFPhF6A@mail.gmail.com
Whole thread Raw
In response to Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values  (Sayyid Ali Sajjad Rizavi <sasrizavi@gmail.com>)
Responses Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values
List pgsql-hackers
Tree view
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 by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Fix showing XID of a spectoken lock in an incorrect field of pg_locks view.
Next
From: Sayyid Ali Sajjad Rizavi
Date:
Subject: Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values