MIME-Version: 1.0
References: 
 <CAN6TVjmHzo-ruRJF_5SmySV-ejygkTqf08saqixaF3xuhex=wg@mail.gmail.com>
In-Reply-To: 
 <CAN6TVjmHzo-ruRJF_5SmySV-ejygkTqf08saqixaF3xuhex=wg@mail.gmail.com>
From: Guillaume Lelarge <guillaume@lelarge.info>
Date: Mon, 14 Oct 2024 20:18:26 +0200
Message-ID: 
 <CAECtzeX1cYxwfi0toeEMhPxjRqVS_2+5_ks8CmJyciaA_bweKg@mail.gmail.com>
Subject: Re: create foreign table
To: Sam Stearns <sam.stearns@dat.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a5ce03062473dd18"
Archived-At: 
 <https://www.postgresql.org/message-id/CAECtzeX1cYxwfi0toeEMhPxjRqVS_2%2B5_ks8CmJyciaA_bweKg%40mail.gmail.com>
Precedence: bulk

--000000000000a5ce03062473dd18
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

Le lun. 14 oct. 2024 =C3=A0 20:14, Sam Stearns <sam.stearns@dat.com> 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 are
> 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.

>

--=20
Guillaume.

--000000000000a5ce03062473dd18
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi,<br></div><br><div class=3D"gmail_quot=
e"><div dir=3D"ltr" class=3D"gmail_attr">Le=C2=A0lun. 14 oct. 2024 =C3=A0=
=C2=A020:14, Sam Stearns &lt;<a href=3D"mailto:sam.stearns@dat.com">sam.ste=
arns@dat.com</a>&gt; a =C3=A9crit=C2=A0:<br></div><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex"><div dir=3D"ltr">Howdy,<div><br></div><div>Receivi=
ng an error without much detail when creating a foreign table:</div><div><b=
r></div><div>2024-10-14 11:08:30.928 PDT [1177724] ERROR: =C2=A0conflicting=
 or redundant options<br>2024-10-14 11:08:30.928 PDT [1177724] STATEMENT: =
=C2=A0CREATE FOREIGN =C2=A0TABLE ext_invalids (<br>=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 validcargo char(8),<br>=C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 validauto char(8),<br>=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 cllocid char(8),<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 insdid char(6),<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 memberid char(14),<br>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 attachdate char(12),<br>=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 commonauthority char(1=
),<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 contractautho=
rity char(1),<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 co=
mpname char(60),<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 docket_num char(9)<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 ) SERVER external_dat_di=
r OPTIONS(filename &#39;DISABLED&#39;, format &#39;csv&#39;, delimiter &#39=
;,&#39;, program &#39;&#39;);</div><div><br></div><div>I&#39;m not seeing m=
uch out there on the error.=C2=A0 I&#39;m also not seeing what are valid va=
lues for the=C2=A0OPTIONS keyword in the Postgres documentation.</div><div>=
<br></div><div>Would=C2=A0someone be able to give advice here, please?</div=
><div><br></div></div></blockquote><div><br></div><div>Saying which FDW you=
&#39;re using would help, but I guess it&#39;s file_fdw.</div><div><br></di=
v><div>You can&#39;t specify both filename and program. You have to choose =
one of them.</div><div><br></div><div>Regards.<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">
</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pre=
fix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr"><div><div dir=3D"ltr"><div>Guillaume.<br></div></div></div></div></div>=
</div>

--000000000000a5ce03062473dd18--