Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0jyO-00CxLT-A0 for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 16:00:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t0jyM-0086zf-Mu for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 16:00:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0jyM-0086zW-AR for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 16:00:34 +0000 Received: from mail-mw2nam10olkn2106.outbound.protection.outlook.com ([40.92.42.106] helo=NAM10-MW2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0jyK-001CvK-4X for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 16:00:34 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=dyDnauuRZ+VMV14qj6ccwwxmwvEIByh/CkIo1RTMK6LZgbT1MdAE/3c8Bki4hx5aMofY3pJaxG5ufLx5mk9D+sqcOY6wvlbvf286eLVh+V2o+lI/tREXbQRA3tlDSm6tdbk/swiT9NJI/UHt5UnmZCHgWWCL9BxF+zliJGo1TIc7gMuSly6Yr/C1TKtITM4WnqiuNsBms2geTTpMf3oWxMANyVSzsnM/SEVlOm8pDEJHFdmkmt4pEfuYp0OX0aNwMJWhoNl0yT+dwTVcKm0gPkBInbeFgkxQYoA6N0xfY0cVSPCEatU+752BHAg6Ly+aa3b2CiKIxJbhfuTrETnwOA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=CGB7F7lBr8seyaEkpReEfXCmpa6sgSMYlSYi6GibGGk=; b=wDzZGaZPvWCTMx2yXg0KRHMRV+zn+m0kQH6YYNr1ETzLZ4hL/QIzFeDgKh0CKd0RpQyngvGlMSb1nogO2jzkVshriiuezidey4yDXVJpo3Xlx6jLctDSBBoUhrTpiQAJhz5g9dAHJMx/kbA1chmesMQMOLsGZ4mxQjheqt7WOhzj2VELS1voDhhit+wle9djxZK/UROSkJqSPxJxtfNEsTPF8JZXNVFIRhUHWefxfZCjbtqWNt31PrtywOiV5YCELSmKGtnzfDnGVGGpbFh+jnesBqoWQNQAg073zeHkKmNrDz3LKDYN5yiLP/518I5dkdlMQLcZsLOZoNfgdsGpgw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=CGB7F7lBr8seyaEkpReEfXCmpa6sgSMYlSYi6GibGGk=; b=rgBkt7UlzJsoaABCEO5UkpfuUADJIWmHtim5O0XLCfGF7a+aglmeFpuxxUMCLXptutRA7A8gFeFX0/B3+L7ZXnlvGzIkbLudg+dSdp5eRhvYyUcnJunWlUR+X4Bt56TPuYLV7VyUHTmO/bUmliI9+jCsRR/1PXX/iM9ylD4MXvm6IKD6NA/vzGWv1Q7MqFqBz1bihQVAFWXZ3aMwHUQe4fStlCVzmwEYFB/fcVvzG8BTLrRW9Wdyw3lqDqzwpt0XAqkzoc+69NeLyJqg2WRg6c3Dc8OvT/pctysJ/Mz/JuNAmYHPayGt9XfV/gTL8FnaPJTEzIx45OS7BBD6xb08Gg== Received: from MN0PR20MB4912.namprd20.prod.outlook.com (2603:10b6:208:3c0::13) by DS0PR20MB5029.namprd20.prod.outlook.com (2603:10b6:8:c3::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8069.15; Tue, 15 Oct 2024 16:00:27 +0000 Received: from MN0PR20MB4912.namprd20.prod.outlook.com ([fe80::2b55:f111:9de9:3cd9]) by MN0PR20MB4912.namprd20.prod.outlook.com ([fe80::2b55:f111:9de9:3cd9%4]) with mapi id 15.20.8069.009; Tue, 15 Oct 2024 16:00:27 +0000 From: vignesh kumar To: Guillaume Lelarge , Sam Stearns CC: Pgsql-admin Subject: Re: create foreign table Thread-Topic: create foreign table Thread-Index: AQHbHmTwa5vwgbMPYk6lJ+E8lwbvCrKGjiIAgAFrd88= Date: Tue, 15 Oct 2024 16:00:26 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-reactions: allow x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: MN0PR20MB4912:EE_|DS0PR20MB5029:EE_ x-ms-office365-filtering-correlation-id: e05ff17f-726d-4e4d-0301-08dced327c49 x-microsoft-antispam: BCL:0;ARA:14566002|19110799003|461199028|12050799009|8062599003|8060799006|7092599003|14030799003|15080799006|9400799024|102099032|10035399004|3412199025|4302099013|440099028|1602099012; x-microsoft-antispam-message-info: =?iso-8859-1?Q?nIO1dKt2guYoZbTJwJhvgy4LTpafg1UbNqSFSMCH8wGFCKcLgcV5Dv23YY?= =?iso-8859-1?Q?K4kbu+lRYwUSNxjduGdvhpdSomWBkvm4Rntx93ItZyoL8fhDmv5vqkPfnC?= =?iso-8859-1?Q?BdfCRm4oWjHnE4BsSqctpuUDY97ECLKSdFAX27huWMFybjQWtZQ0HhVfxg?= =?iso-8859-1?Q?hars4AtDXkXc25CUFJ8FugE2604v38vph/lpGLoLHRma9baZq5nCM5eXlf?= =?iso-8859-1?Q?EWVENBX0VGASi7oKxKzTOz78JBNu+LMrPmRim6OqJSP40IEGYlA0Yt4ta9?= =?iso-8859-1?Q?BQAviuVkqWwz/6gCCYnUx7ArkFp0yBFsR9LtL7K4PNR9qTa54EewDDUI4F?= =?iso-8859-1?Q?feA92D/P+9l+Il4b2DPBq3HFQxexkdKVhOaO8v5td9C1qoGKnsJqMTvEUW?= =?iso-8859-1?Q?33H+Mq3hP0nCQO9dt8rH4L355inbhEsEeFiFsbh0heN1K0Ukk4E1K+7boM?= =?iso-8859-1?Q?Ht3+pk2LBtFPgw/rB3Ns8itjyzp7v2mLyj0Ze1GEbGow8B7CKprDbbz7Rw?= =?iso-8859-1?Q?AhKn8kyTUk794pviQztztmwG8CseKP6KL+Yefy4KOJJbAQd0p6Hs+Bkn4m?= =?iso-8859-1?Q?LkSf+KPdZRfrkgFzkClvQU2JQQ1zxMMAozPeYJIxgm4czMx5tA/EKjyoJz?= =?iso-8859-1?Q?NlPtcgtDYhf59D1b/ca8AUEt9sFJq3uYJiQTdF48CAE15lp6F54TjTHLDd?= =?iso-8859-1?Q?aKTLH13UUr4CS8ZlbAOXnj2Gqq2UfIZDeScmb4glzNCs7cVyPOahG1RPne?= =?iso-8859-1?Q?sJCWTmOom7uf/rKzoeXQAwNxEzTLEuGdJLOAyd7v94NeGyBFIF4aPu+XzO?= =?iso-8859-1?Q?URFWXuZVUUD160bQIGE7xW1rWUQT2peJiejJ9d++twF62rT9m9wnpFPDCP?= =?iso-8859-1?Q?Pinb4PhaKGpMbsXAl3nlOaeVWUzzPh4fDkMW7LXlSDjb/M9SuiKwi3CZbD?= =?iso-8859-1?Q?lhLO4HLzP/NJqk01v5BAj/rZmFEMKe7c0s93xLPCwu+XiFZlsi8QWg=3D?= =?iso-8859-1?Q?=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?Y4dMlM9KzinnJrrJ2zH8e9VNq4ev53uEkJa2Bm5xYeS496pJsl4JMZM0wv?= =?iso-8859-1?Q?mrFmz/1/dTWGWdNUv3byAamLUjEiqZwWSDbR2EDQf5EF3qFOhUO8kw0YEw?= =?iso-8859-1?Q?frDwc9POjtGrdXDTqzfGdAlRoi23Ut4jm5sgPeRi8GvUbGEfky6KykVSX6?= =?iso-8859-1?Q?pnKY6cniqGn7kMFtbuhItqlZJEvvxgHXm721T7GbX3WljKX8yiW9mks597?= =?iso-8859-1?Q?s8lMar+1QJlsyHg14Ku6Z3Q+TPC4q2SzDjpjyQNH4caWOJT2PqHFuLaTPx?= =?iso-8859-1?Q?NmzGYWh3ogwv/YV0b/8AgXoQm+9qLSlSry4M7W7a/+EY5ucuFVexHnpGAW?= =?iso-8859-1?Q?Fp8NSoOQP/Vm3HdTGJWLJetkzsEHx4iLCSZiREc0EnEsEMu/pRpEp3usp/?= =?iso-8859-1?Q?Xk/VEq4Tu6nsGhwmjYS5STV5qWNE/dy9AmXhiJh/U5VVmVnoqu2XVx76xR?= =?iso-8859-1?Q?45nLzMnM3z6Ki4RySkoQiCMkFutcantwb28OrrSHSAgkFZq36GNKi6lUML?= =?iso-8859-1?Q?H8yFMHyr3YcqyNgvnW+wcPXtQNCjKhR6ON+A8eNKTISVqFLlb6E5T0qC9C?= =?iso-8859-1?Q?ljp4zT/Z0ufheiO9WQidR01DG5wv/Yfx4mBxxDXzHVTeTXHBNQBScO7API?= =?iso-8859-1?Q?wXSchHggXtpjS4EZptfE7EPO9b4Hm8+Qj4aqvKf6qRaMtJvkq3dMsB7Y1L?= =?iso-8859-1?Q?5MkQ2gJDlNU0BdEyavjSNYtyscRsu6zQ33WG1iOefl9UmKDrqDII92CV/p?= =?iso-8859-1?Q?4pwt6DnI3fhRzsyVXhiUAi1APjqKwjcmXx8LpNcClfBfQmj/dAVZZtc1V2?= =?iso-8859-1?Q?yJNWeAJwfI032+2e2RgizvHA5l8e/q1CSeeijO+9DZs7Ug1rZv/I3IRY1p?= =?iso-8859-1?Q?ovHHh/7fzLeRdSmPEwni1gED74qkFyaStvEy7WPRTp/TcP+u15QJM0c3XQ?= =?iso-8859-1?Q?uoqMR7INBfX5braaIJJxE9wPC9CJZlaaCsYBEgDYkhzxpXon9dL0Tdt6Ju?= =?iso-8859-1?Q?g2byTomOuEbZL5HqDw6LDHMbB9zxpqNbwIwlc9wwPL7hGcgAJGH0Z4U70W?= =?iso-8859-1?Q?O1Stk8qahUJm7byFR2CamWrfJDHe24mlzCqxLc2+VSG2HWGX4NrfIRAsrp?= =?iso-8859-1?Q?u/cNVBBxWreyLdNnh5SGV+Zd2Dn7hgMBHhl2KD7FuhydNBQW89y3z7vaq/?= =?iso-8859-1?Q?FCcrWnPzRYTyqT9o91VWHxfYmA9uRITrygZDvlrbzhLuG2OGS1nKDW77UY?= =?iso-8859-1?Q?+36qVbMwQUdRFuH55bbIbqivmvT5Tm/+0ZPST7QoufdDW1I4dWgzH0XJiD?= =?iso-8859-1?Q?t/DQQ+r4JSyKumjuorGk58FZMPmmlmJn5ysU/ZxWuYv41zQ=3D?= Content-Type: multipart/alternative; boundary="_000_MN0PR20MB49129D639A74585E7D8E3C6187452MN0PR20MB4912namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MN0PR20MB4912.namprd20.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: e05ff17f-726d-4e4d-0301-08dced327c49 X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Oct 2024 16:00:26.8729 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DS0PR20MB5029 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_MN0PR20MB49129D639A74585E7D8E3C6187452MN0PR20MB4912namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable First you need to create foreign server, foreign data wrapper then followed= by granting access to use the postgres_fdw.. then try accessing it.. that'= s the optimal way.. I'm not getting what is being tried here Sent from Outlook for Android ________________________________ From: Guillaume Lelarge Sent: Monday, October 14, 2024 11:48:26 PM To: Sam Stearns Cc: Pgsql-admin Subject: Re: create foreign table Hi, Le lun. 14 oct. 2024 =E0 20:14, Sam Stearns > a =E9crit : Howdy, Receiving an error without much detail when creating a foreign table: 2024-10-14 11:08:30.928 PDT [1177724] ERROR: conflicting or redundant opti= ons 2024-10-14 11:08:30.928 PDT [1177724] STATEMENT: CREATE FOREIGN TABLE ext= _invalids ( validcargo char(8), validauto char(8), cllocid char(8), insdid char(6), memberid char(14), attachdate char(12), commonauthority char(1), contractauthority char(1), compname char(60), docket_num char(9) ) SERVER external_dat_dir OPTIONS(filename 'DISABLED', format 'csv'= , delimiter ',', program ''); I'm not seeing much out there on the error. I'm also not seeing what are v= alid values for the OPTIONS keyword in the Postgres documentation. Would someone be able to give advice here, please? Saying which FDW you're using would help, but I guess it's file_fdw. You can't specify both filename and program. You have to choose one of them= . Regards. -- Guillaume. --_000_MN0PR20MB49129D639A74585E7D8E3C6187452MN0PR20MB4912namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
First you need to create foreign server, foreign data wra= pper then followed by granting access to use the postgres_fdw.. then try ac= cessing it.. that's the optimal way.. I'm not getting what is being tried h= ere

From: Guillaume Lelarge <= ;guillaume@lelarge.info>
Sent: Monday, October 14, 2024 11:48:26 PM
To: Sam Stearns <sam.stearns@dat.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: create foreign table
 
Hi,

Le lun. 14 oct. 2024 =E0 = 20:14, Sam Stearns <sam.stearns@d= at.com> a =E9crit :
Howdy,

Receiving an error without much detail when creating a foreign table:<= /div>

2024-10-14 11:08:30.928 PDT [1177724] ERROR:  conflicting or redu= ndant options
2024-10-14 11:08:30.928 PDT [1177724] STATEMENT:  CREATE FOREIGN  = ;TABLE ext_invalids (
                validcargo char(8),=
                validauto char(8),<= br>                 cllocid char(8),                 insdid char(6),
                memberid char(14),<= br>                 attachdate char(12)= ,
                commonauthority cha= r(1),
                contractauthority c= har(1),
                compname char(60),<= br>                 docket_num char(9)<= br>         ) SERVER external_dat_dir OPTIONS(filename 'DIS= ABLED', format 'csv', delimiter ',', program '');

I'm not seeing much out there on the error.  I'm also not seeing = what are valid values for the OPTIONS keyword in the Postgres document= ation.

Would someone be able to give advice here, please?


Saying which FDW you're using would help, but I guess it's file_fdw.

You can't specify both filename and program. You have to choose one of= them.

Regards.


--
Guillaume.
--_000_MN0PR20MB49129D639A74585E7D8E3C6187452MN0PR20MB4912namp_--