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
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
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
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
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
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
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
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 F
