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 <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
