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 1t0QFy-00BLaa-9z for pgsql-admin@arkaria.postgresql.org; Mon, 14 Oct 2024 18:57:26 +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 1t0QFu-00G7cz-VV for pgsql-admin@arkaria.postgresql.org; Mon, 14 Oct 2024 18:57:23 +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 1t0QFu-00G7be-H4 for pgsql-admin@lists.postgresql.org; Mon, 14 Oct 2024 18:57:22 +0000 Received: from mx0b-0039f802.pphosted.com ([205.220.176.45]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0QFp-0013KC-Tc for pgsql-admin@lists.postgresql.org; Mon, 14 Oct 2024 18:57:21 +0000 Received: from pps.filterd (m0209982.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 49EGWbUe031626 for ; Mon, 14 Oct 2024 11:57:16 -0700 Received: from mail-yw1-f198.google.com (mail-yw1-f198.google.com [209.85.128.198]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 427q82a1r5-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Mon, 14 Oct 2024 11:57:16 -0700 (PDT) Received: by mail-yw1-f198.google.com with SMTP id 00721157ae682-6e35bdb6a31so42834617b3.1 for ; Mon, 14 Oct 2024 11:57:16 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728932236; x=1729537036; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=mrp6YXoxPAWPf6ik0ziZ9Lsm9VRrQvR8oJYZH5Slf/g=; b=TNwcSkrJd3ZKV65k3akQv6B3oYYGSs28//HtdvZYwIr/S6YdIZBIRam+2tjUDimVbB ctRTCSb/z6DiSMQVoQfM3eVIqiTI5VWPJ9JOsnNW0l6VZk3BpsLAvdNGHvur4SZvWitT vxoPkyDcb3cm0LcAargcINk5euFcFqSidPAJQ37ZhnIauHxBidknUAQ5qSiZ9+V1PRiP KriSV2VYrSw8d4nr7u4887L1Wpqr+6yZMWpak0f7uYGFKEGqkL4LJmY6qllzp9ihiQsP A/INOoMMAmGE00rdB17PxwmcRib4MlRiSE1ynstUfxClNK1katLyebOS/kyii56SsW9U Q1jA== X-Gm-Message-State: AOJu0YyGj3elIr7v2qrsDnVwMErRfcEkl0SbQ8lCznumIaEQ5B665kG1 shEt+Hg566HLfAD2ge2p7quGam+ILsIP1xT3fnqEWgCnsZyY8DM7uLrTVhDphCI0UqFY5eE/FJq /nsyqn+4LSdiKxS/83s96CNTY6L3p0HOMLLolwl0woaefg9OSULegHBHCYvbGMLi5jtXuj8LxW8 TdU0wSLBvs6TkCqEC3biWA+zL8nxdkuTEwGBizvni67qfPmYPY4aver6HDPfBTcoZw38E= X-Received: by 2002:a05:690c:90:b0:6e3:8760:29b6 with SMTP id 00721157ae682-6e387602c20mr46969227b3.34.1728932235862; Mon, 14 Oct 2024 11:57:15 -0700 (PDT) X-Google-Smtp-Source: AGHT+IHtpQxdvUSR9hRZPdCTMmvf2eT1Pf3tFsSMvF7gYbXDx+Bv3F6QXXsV4pAsezm52LgUXOvKQpmT+mtSVSZcNA8= X-Received: by 2002:a05:690c:90:b0:6e3:8760:29b6 with SMTP id 00721157ae682-6e387602c20mr46969007b3.34.1728932235203; Mon, 14 Oct 2024 11:57:15 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sam Stearns Date: Mon, 14 Oct 2024 11:57:04 -0700 Message-ID: Subject: Re: create foreign table To: Guillaume Lelarge Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000b86fb606247467ba" X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1051,Hydra:6.0.680,FMLib:17.12.62.30 definitions=2024-10-14_12,2024-10-11_01,2024-09-30_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b86fb606247467ba Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable That did the trick. Thank you! Sam On Mon, Oct 14, 2024 at 11:18=E2=80=AFAM Guillaume Lelarge wrote: > Hi, > > Le lun. 14 oct. 2024 =C3=A0 20:14, Sam Stearns a = =C3=A9crit : > >> 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 >> options >> 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 ar= e >> valid 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. > --=20 *Samuel Stearns* Lead Database Administrator *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com [image: DAT] --000000000000b86fb606247467ba Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
That did the trick.=C2=A0 Thank you!

Sa= m


On Mon, Oct 14, 2024 at 11:18=E2=80=AFAM Guillaume Le= large <guillaume@lelarge.info<= /a>> wrote:
<= div dir=3D"ltr">
Hi,

Le=C2=A0lun. 14 oct. 2024 =C3=A0=C2= =A020:14, Sam Stearns <sam.stearns@dat.com> a =C3=A9crit=C2=A0:
Howdy,

Receiving an error without much detail when creating a foreign tabl= e:

2024-10-14 11:08:30.928 PDT [1177724] ERROR: = =C2=A0conflicting or redundant options
2024-10-14 11:08:30.928 PDT [1177= 724] STATEMENT: =C2=A0CREATE FOREIGN =C2=A0TABLE ext_invalids (
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 validcargo char(8),
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 validauto char(8),
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 cllocid char(8),=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 insdid char(6),=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 memberid char(14),=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 attachdate char= (12),
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 commonauth= ority char(1),
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 c= ontractauthority char(1),
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 compname char(60),
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 docket_num char(9)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 ) SERVER ex= ternal_dat_dir OPTIONS(filename 'DISABLED', format 'csv', d= elimiter ',', program '');

I'm= not seeing much out there on the error.=C2=A0 I'm also not seeing what= are valid values for the=C2=A0OPTIONS keyword in the Postgres documentatio= n.

Would=C2=A0someone 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 ha= ve to choose one of them.

Regards.


--
Guillaume.
=

--

Samuel Stearns
Lead Database Administrat= or
c:=C2=A0971 762 6879=C2=A0|=C2=A0o:=C2=A0503 672 5115=C2=A0|=C2=A0DAT.com

3D=
--000000000000b86fb606247467ba--