On 03/27/2015 01:55 PM, Deven Phillips wrote:
Better example of the problem... My FDW table schema is:CREATE FOREIGN TABLE liquorstore_backendipaddress ( id bigint NOT NULL, backend_network_id bigint, backend_virtual_interface_id bigint, address character varying(15) NOT NULL, is_gateway boolean NOT NULL, is_reserved boolean NOT NULL ) SERVER edison OPTIONS ( dbname 'edison', table_name 'liquorstore_backendvirtualinterface' ); But when I run the following query: SELECT * FROM liquorstore_backendipaddress I get an error: ccedison=# SELECT * FROM liquorstore_backendipaddress; ERROR: failed to prepare the MySQL query: Unknown column 'backend_network_id' in 'field list'
So is 'backend_network_id' in the MySQL table?
I still cannot figure out what the problem might be so any help would be GREATLY appreciated. Thanks, Deven On Fri, Mar 27, 2015 at 4:15 PM, Deven Phillips <deven.phill...@gmail.com <mailto:deven.phill...@gmail.com>> wrote: I am trying out some ideas using FDW, and I have added some FDW tables which access a backend MySQL DB... Unfortunately, I am getting some errors because of fields names with reserved words. I was wondering if there is a way to "alias" a field name when creating the foreign table? Thanks in advance!!! Deven
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
