From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Dian M Fay" <dian(dot)m(dot)fay(at)gmail(dot)com> |
Cc: | "David Steele" <david(at)pgmasters(dot)net>, "Georgios Kokolatos" <gkokolatos(at)protonmail(dot)com>, "PostgreSQL Developers" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: [PATCH] postgres_fdw: suppress explicit casts in text:text comparisons (was: column option to override foreign types) |
Date: | 2021-11-12 16:54:20 |
Message-ID: | 1727334.1636736060@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Dian M Fay" <dian(dot)m(dot)fay(at)gmail(dot)com> writes:
> Eminently reasonable all around! `git apply` insisted that the v8 patch
> didn't (apply, that is), but `patch -p1` liked it fine. I've put it
> through a few paces and it seems good; what needs to happen next?
I don't see anything else to do except shove it out into the light
of day and see what happens. Hence, pushed.
As I remarked in the commit message:
>> One point that I (tgl) remain slightly uncomfortable with is that we
>> will ignore an implicit RelabelType when deciding if the non-Const input
>> is a plain Var. That makes it a little squishy to argue that the remote
>> should resolve the Const as being of the same type as its Var, because
>> then our Const is not the same type as our Var. However, if we don't do
>> that, then this hack won't work as desired if the user chooses to use
>> varchar rather than text to represent some remote column. That seems
>> useful, so do it like this for now. We might have to give up the
>> RelabelType-ignoring bit if any problems surface.
I think we can await complaints before doing more, but I wanted that
bit on record for anyone perusing the archives.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2021-11-12 16:55:17 | SKIP LOCKED assert triggered |
Previous Message | Daniel Gustafsson | 2021-11-12 16:04:08 | Re: Commitfest 2021-11 Patch Triage - Part 2 |