Re: [HACKERS] postgres_fdw does not see enums

2014-12-05 Thread Merlin Moncure
On Wed, Dec 3, 2014 at 5:17 PM, Tom Lane wrote: > David Fetter writes: >> On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote: >>> What do you mean "reconstruct the enum"? > >> Capture its state at the time when IMPORT FOREIGN SCHEMA is executed. >> Right now, if you try IMPORT SCHEMA on a f

Re: [HACKERS] postgres_fdw does not see enums

2014-12-03 Thread David Fetter
On Wed, Dec 03, 2014 at 06:17:51PM -0500, Tom Lane wrote: > David Fetter writes: > > On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote: > >> What do you mean "reconstruct the enum"? > > > Capture its state at the time when IMPORT FOREIGN SCHEMA is executed. > > Right now, if you try IMPORT

Re: [HACKERS] postgres_fdw does not see enums

2014-12-03 Thread Tom Lane
David Fetter writes: > On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote: >> What do you mean "reconstruct the enum"? > Capture its state at the time when IMPORT FOREIGN SCHEMA is executed. > Right now, if you try IMPORT SCHEMA on a foreign table with an enum in > it, postgresql_fdw errors

Re: [HACKERS] postgres_fdw does not see enums

2014-12-03 Thread David Fetter
On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote: > David Fetter writes: > > On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote: > >> No. How would you know whether the remote side even has the enum, > >> let alone whether it has an identical set of members? I don't see > >> that e

Re: [HACKERS] postgres_fdw does not see enums

2014-12-03 Thread Tom Lane
David Fetter writes: > On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote: >> No. How would you know whether the remote side even has the enum, >> let alone whether it has an identical set of members? I don't see >> that enums are noticeably easier than the general case of >> non-built-in

Re: [HACKERS] postgres_fdw does not see enums

2014-12-03 Thread David Fetter
On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote: > David Fetter writes: > > 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? > > No. How would you know whether the remote side even has the enu

Re: [HACKERS] postgres_fdw does not see enums

2014-12-03 Thread Tom Lane
David Fetter writes: > 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? No. How would you know whether the remote side even has the enum, let alone whether it has an identical set of members? I don't see th