Re: [GENERAL] Enum in foreign table: error and correct way to handle.

2015-05-24 Thread Peter Swartz
Thank you for the message Tom; sounds great. I'll try that out, will check on the planner's resultant behavior and email back. Peter On Sat, May 23, 2015 at 12:35 PM, Tom Lane wrote: > Peter Swartz writes: > > suppose the foreign database adds a value to the enum, and th

Re: [GENERAL] Enum in foreign table: error and correct way to handle.

2015-05-23 Thread Peter Swartz
gards, Peter On Thu, May 21, 2015 at 8:06 PM, Ian Barwick wrote: > On 21/05/15 04:23, Peter Swartz wrote: > > 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 >

[GENERAL] Enum in foreign table: error and correct way to handle.

2015-05-20 Thread Peter Swartz
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 followi