Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W5dLW-00028z-Uy for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jan 2014 15:34:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W5dLW-0000UU-Bg for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jan 2014 15:34:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W5dLU-0000S2-MC for pgsql-bugs@postgresql.org; Tue, 21 Jan 2014 15:34:32 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W5dLO-0000cA-4Q for pgsql-bugs@postgresql.org; Tue, 21 Jan 2014 15:34:32 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id CEB305F7B2; Tue, 21 Jan 2014 10:34:53 -0500 (EST) Date: Tue, 21 Jan 2014 10:34:53 -0500 From: Stephen Frost To: byteslayer7@gmail.com Cc: pgsql-bugs@postgresql.org Subject: Re: BUG #8901: postgres_fdw double-qualifying schemas Message-ID: <20140121153453.GO31026@tamriel.snowman.net> References: <20140121140504.26700.70742@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Iys0Un1O+0sigPHU" Content-Disposition: inline In-Reply-To: <20140121140504.26700.70742@wrigleys.postgresql.org> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.8.0-35-generic (x86_64) X-Uptime: 10:33:25 up 13 days, 12:47, 4 users, load average: 0.10, 0.07, 0.06 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org --Iys0Un1O+0sigPHU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * 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 --Iys0Un1O+0sigPHU Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJS3pOdAAoJEO1sijiDR2RVWgUP/iC9TZ3GfdMmRkaJvctIEpnD JoJ2iqjNXqKyUOfe5UNzc2IghHWD6AUHZ3lQB+0q8h2OGD2qzkh2tZlAGi7SeZUF wB32RnAJd7CIeST6AJVa3fb88dBbVxF2Ywkpwl1TLxf5/y2y3dF7eYvWMXzOci+j Y8EXiUg0hcrZu5qPa/X7bZe3qZ/TFlMjPThDYW4RfHTVLFPtuYLm4uPTA6TCVk97 7t24lj81JTG8QHwUm6qyBGa9qFH91rqgpIK0jBpHi+SNyCSX+DF44BHxpy3kmvCr YeHVrqvWndyElweCmDtd43LywpJLORvb+dV+5wfWvocPikcSyeiJV6Pp18DFm0gh m1lJGvC8rA72J37FnCqkwvvDclApnthToM+yxdHkzqTHei8ZI306WD2fgKYl/ISU X26VpSFwUoD0ZBHycjnJ2F5XrtxXdcxgrvkPZscZB0r/sHbTKXh7ftxMOS7RKjm+ fcrdowGE6eaeC6X9MJfTHbSiWu1Cte4X690JX/85K9U6A1MYP85tHYAH+4PJKE7P Rnm3AL/CvpRy6umOm7n3JoU0vbGfPvP3x4wKUwjiWlJMGT1ZeukHcKhMMfRt8sOF nSo+mXki3sKMWn2pgwNDQZvAWSOnZlTOOhYn1BM2U5B0WquCO/RFhbZz6kqg1xjA 4InueLGwosWbRvCb5k9/ =9opo -----END PGP SIGNATURE----- --Iys0Un1O+0sigPHU--