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
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 |