forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commited3ddf9
committed
Introduce less-bogus handling of collations in contrib/postgres_fdw.
Treat expressions as being remotely executable only if all collations usedin them are determined by Vars of the foreign table. This means that, ifthe foreign server gets different answers than we do, it's the user's faultfor not having marked the foreign table columns with collations equivalentto the remote table's. This rule allows most simple expressions such as"var < 'constant'" to be sent to the remote side, because the constantisn't determining the collation (the Var's collation would win). There'sstill room for improvement, but it's hard to see how to do it without alot more knowledge and/or assumptions about what the remote side will do.1 parent209f675 commited3ddf9
File tree
3 files changed
+474
-60
lines changed- contrib/postgres_fdw
- expected
- sql
3 files changed
+474
-60
lines changed0 commit comments
Comments
(0)