Postgres Pro
Downloads
Home   >   mailing lists

Enum in foreign table: error and correct way to handle. - Mailing list pgsql-general

From Peter Swartz
Subject Enum in foreign table: error and correct way to handle.
Date
Msg-id CAGhmnP2bKk5BbAa0ndRvLyULGWzXnD8U+epu6zJFByKw7q1J1Q@mail.gmail.com
Whole thread Raw
Responses Re: Enum in foreign table: error and correct way to handle.  (Ian Barwick <ian@2ndquadrant.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Michael Nolan
Date:
Subject: Re: Consistent state for pg_dump and pg_dumpall
Next
From: John R Pierce
Date:
Subject: Re: Consistent state for pg_dump and pg_dumpall