Filtering on an enum field in a foreign table

I am querying a remote server through a foreign table definition. CREATE TABLE example (id integer, product product_enum, status status_enum) Where CREATE TYPE status AS ENUM ('active', 'testing', 'inactive', ...); CREATE TYPE product AS ENUM ('a', 'b', 'c', ...); I re-created enums on my serve

Re: Filtering on an enum field in a foreign table

Hi, On Tue, Jul 16, 2019 at 4:00 PM Vladimir Ryabtsev wrote: > I am querying a remote server through a foreign table definition. > > CREATE TABLE example (id integer, product product_enum, status status_enum) > ... > When I am querying the foreign table on enum predicate like > > select * from

Re: Filtering on an enum field in a foreign table

Sorry, the version() is "PostgreSQL 10.3 (Ubuntu 10.3-1.pgdg14.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.4) 4.8.4, 64-bit" I gave use_remote_estimate a try but unfortunately it is the same. Additionally I see on your page (in "Remote Execution Options"): "By def

Re: Filtering on an enum field in a foreign table

Wait folks, I realized that if I create a basic view with enum fields converted to text, it does the trick! I query the view with text predicate and the view implementation (I think) converts it into enums when querying the underlying table. But I still think it should work without such workaroun