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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate