Re: BUG #8901: postgres_fdw double-qualifying schemas - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8901: postgres_fdw double-qualifying schemas
Date
Msg-id 29750.1390324346@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #8901: postgres_fdw double-qualifying schemas  (Stephen Frost <sfrost@snowman.net>)
List pgsql-bugs
Stephen Frost <sfrost@snowman.net> writes:
> * byteslayer7@gmail.com (byteslayer7@gmail.com) wrote:
>> I posted a question on Stackoverflow regarding postgres_fdw. I was advised
>> to report it here and link to it:
>> [...]
>> ) SERVER export_server OPTIONS (table_name 'export_schema.aa');
>> SELECT * FROM import_schema.aa;
>>
>> Which I expect to work, instead gives this error:

> Use: OPTIONS (schema_name 'export_schema' table_name 'aa'); above.

This is documented in the postgres_fdw reference page, but I notice that
page has absolutely no examples.  A concrete example or two might help
perhaps.  Anybody feel like working up a patch?

            regards, tom lane


pgsql-bugs by date:

Previous
From: Stephen Frost
Date:
Subject: Re: BUG #8901: postgres_fdw double-qualifying schemas
Next
From: Mikhail Pryakhin
Date:
Subject: Socket unexpectedly closed by a frontend while communicating with the backend