Content-Length: 242450 | pFad | http://github.com/postgrespro/postgres/commit/ed3ddf918b59545583a4b374566bc1148e75f593

AE Introduce less-bogus handling of collations in contrib/postgres_fdw. · postgrespro/postgres@ed3ddf9 · GitHub
Skip to content

Commit ed3ddf9

Browse files
tglsfdctglsfdc
committed
Introduce less-bogus handling of collations in contrib/postgres_fdw.
Treat expressions as being remotely executable only if all collations used in them are determined by Vars of the foreign table. This means that, if the foreign server gets different answers than we do, it's the user's fault for not having marked the foreign table columns with collations equivalent to the remote table's. This rule allows most simple expressions such as "var < 'constant'" to be sent to the remote side, because the constant isn't determining the collation (the Var's collation would win). There's still room for improvement, but it's hard to see how to do it without a lot more knowledge and/or assumptions about what the remote side will do.
1 parent 209f675 commit ed3ddf9

File tree

3 files changed

+474
-60
lines changed

3 files changed

+474
-60
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/ed3ddf918b59545583a4b374566bc1148e75f593

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy