I'm creating a foreign table (foo_table) in database_a. foo_table lives in
database_b.foo_table has an enum (bar_type) as one of its columns. Because
this enum is in database_b, the creation of the foreign table fails in
database_a. database_a doesn't understand the column type. Running the
following in database_a
CREATE FOREIGN TABLE foo_table (id integer NOT NULL, bar bar_type) SERVER
database_b
One gets the error:
ERROR: type "bar_type" does not exist
I could just create a copy of bar_type in database_a, but this feels
duplicative and possibly a future cause of inconsistency / trouble. Would
anyone have thoughts on best practices for handling?
Thank you!
Peter