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

From Stephen Frost
Subject Re: BUG #8901: postgres_fdw double-qualifying schemas
Date
Msg-id 20140121153453.GO31026@tamriel.snowman.net
Whole thread Raw
In response to BUG #8901: postgres_fdw double-qualifying schemas  (byteslayer7@gmail.com)
Responses Re: BUG #8901: postgres_fdw double-qualifying schemas
List pgsql-bugs
* 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;
>=20
> Which I expect to work, instead gives this error:=20

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

    Thanks,

        Stephen

pgsql-bugs by date:

Previous
From: David Fleischhauer
Date:
Subject: Re: permission issues with PostgreSQL 9.2 EnterpriseDB one-click installer on windows 7 causes initcluster to fail
Next
From: Tom Lane
Date:
Subject: Re: BUG #8901: postgres_fdw double-qualifying schemas