postgres_fdw does not see enums

From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: postgres_fdw does not see enums
Date: 2014-12-03 21:31:39
Message-ID: 20141203213139.GA9855@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

I've been trying out 9.5-to-be's PostgreSQL FDW, and I noticed that it
doesn't seem to handle enum types. Would this be a trivial fix?

Repro:
Create an enum type in a 9.3 instance.
Use the type in a table.
Create a foreign server pointing to this instance.
Execute IMPORT FOREIGN SCHEMA.

Pseudonymized output:

db_compare=# IMPORT FOREIGN SCHEMA public FROM SERVER blah INTO blah;
ERROR: type "public.product_type" does not exist
LINE 4: product_type public.product_type OPTIONS (column_name 'pro...
^
QUERY: CREATE FOREIGN TABLE foo (
id integer OPTIONS (column_name 'id') NOT NULL,
event_id integer OPTIONS (column_name 'event_id') NOT NULL,
product_type public.product_type OPTIONS (column_name 'product_type')
) SERVER blah
OPTIONS (schema_name 'public', table_name 'foo');
CONTEXT: importing foreign table "foo"

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-12-03 22:38:47 Re: postgres_fdw does not see enums
Previous Message Robert Haas 2014-12-03 21:18:11 Re: tracking commit timestamps