MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Mon, 14 Oct 2024 11:14:05 -0700
Message-ID: 
 <CAN6TVjmHzo-ruRJF_5SmySV-ejygkTqf08saqixaF3xuhex=wg@mail.gmail.com>
Subject: create foreign table
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000005a052062473ce4b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVjmHzo-ruRJF_5SmySV-ejygkTqf08saqixaF3xuhex%3Dwg%40mail.gmail.com>
Precedence: bulk

--00000000000005a052062473ce4b
Content-Type: text/plain; charset="UTF-8"

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?

Thanks,

Sam

-- 

*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

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

<div dir=3D"ltr">Howdy,<div><br></div><div>Receiving an error without much =
detail when creating a foreign table:</div><div><br></div><div>2024-10-14 1=
1: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 contractauthority char(1),<br>=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 compname 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_dir OPTIONS(filename &=
#39;DISABLED&#39;, format &#39;csv&#39;, delimiter &#39;,&#39;, program =
9;&#39;);</div><div><br></div><div>I&#39;m not seeing much out there on the=
 error.=C2=A0 I&#39;m also not seeing what are valid values for the=C2=A0OP=
TIONS 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=
>Thanks,</div><div><br></div><div>Sam<br clear=3D"all"><div><br></div><span=
 class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"g=
mail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><p styl=
e=3D"color:rgb(0,0,0);font-family:Gotham,&quot;Helvetica Neue&quot;,Helveti=
ca,Arial,sans-serif;font-size:0.8rem;line-height:1.2rem"><strong style=3D"f=
ont-size:0.9rem;color:rgb(51,51,51)">Samuel Stearns</strong><br><span style=
=3D"color:rgb(102,102,102)">Lead Database Administrator<br><strong>c:</stro=
ng>=C2=A0971 762 6879=C2=A0<span style=3D"color:rgb(147,149,152)">|</span>=
=C2=A0<strong>o:</strong>=C2=A0503 672 5115=C2=A0<span style=3D"color:rgb(1=
47,149,152)">|</span>=C2=A0DAT.com</span></p><div style=3D"color:rgb(0,0,0)=
;font-family:&quot;Times New Roman&quot;;font-size:medium"><a href=3D"https=
://www.dat.com/?utm_medium=3Demail&amp;utm_source=3DDAT_email_signature_lin=
k" target=3D"_blank"><img src=3D"https://www.dat.com/wp-content/uploads/med=
ia/images/global/emails/signature2/dat_126.png" alt=3D"DAT" width=3D"126" h=
eight=3D"54"></a></div></div></div></div></div>

--00000000000005a052062473ce4b--