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 1t0kaX-00D0T4-W2 for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 16:40:02 +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 1t0kaW-008cBo-CC for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 16:40:00 +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 1t0kaV-008cBM-Vq for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 16:40:00 +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 1t0kaS-001DBt-GP for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 16:39:58 +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 49FGU737010027 for ; Tue, 15 Oct 2024 09:39:53 -0700 Received: from mail-yw1-f197.google.com (mail-yw1-f197.google.com [209.85.128.197]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 427q82b7x1-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Tue, 15 Oct 2024 09:39:53 -0700 (PDT) Received: by mail-yw1-f197.google.com with SMTP id 00721157ae682-6d9e31e66eeso97290187b3.1 for ; Tue, 15 Oct 2024 09:39:53 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729010393; x=1729615193; 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=0i7zxhUCtiNqiEyYZLtW8B+41joQexT1Y1/RzIecaCk=; b=uIf2KqmKwCNa7gqgfmqdLLYD4r+WcWapxbAywbzJfNYc7oNEPYex3rDrzVBhc07+w3 9OHVvw7epntiJucGk0YvK0IRfUoMSmgwONhd1wESp9kMbMP7R5ZRCWSWOhuKuyGLXxNo /1gkVkV/mWno5l18RIJybyT7SPe9o94lPVHhQrXgrl+F/U2sZAvKdKLcjIEY07lsTf6f Tcjk5rZ2ataNUC/ByvswcfZbYfF42a8QBmosTYwbGTOAsCCy8wFK8DCqumd6RDbREYoZ GfQHP98x2DA+O+LQuD4y9cGqj8gpUG7SXPIYGbUwOZaOnJhcq6pHj/Xuc4iWqlwVG1o5 tTjA== X-Forwarded-Encrypted: i=1; AJvYcCWcKu79nKkaiUhh6XtPf3ZqQCGTK3qEJHD0Ishf+QS7wrMzo7qCYqTuxUYUYTfH7DofIOHCDzton6590w==@lists.postgresql.org X-Gm-Message-State: AOJu0YxpSTgkOkG5+EpZlX5Gg0of2Z+kKNJobFemqOwtERUloany/THN 47yaCQyNEk+0H+RvyNXzfqNuUVQrbYZa8wp1bcxhxvp+G4Fx0oNM6S6d57VksQiiAI+dTEJLYmc d3O/ykc/ZSbsFGNJhnzx0z5V2EQtCmVlkC2W17rGmmITqYrImVIzPAXKRcCBiXWxODD3IZKFO16 poEFaByYeWFFXxz8eP82wAqqLshphpcGDmINtt7u77g29D7mVgC6HbS03KRmj/bEalHRQ= X-Received: by 2002:a05:690c:101:b0:6e3:2630:2a0c with SMTP id 00721157ae682-6e3643540a3mr96057497b3.26.1729010392694; Tue, 15 Oct 2024 09:39:52 -0700 (PDT) X-Google-Smtp-Source: AGHT+IHEgeqKAr9NrOqOxIE7SX5fDJKj84e3OVYrsxGomR/f+R4gnt2Xj94MaHooqiXENYO+aowRV7xgyIyUD18tW+g= X-Received: by 2002:a05:690c:101:b0:6e3:2630:2a0c with SMTP id 00721157ae682-6e3643540a3mr96057127b3.26.1729010392131; Tue, 15 Oct 2024 09:39:52 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sam Stearns Date: Tue, 15 Oct 2024 09:39:39 -0700 Message-ID: Subject: Re: create foreign table To: vignesh kumar Cc: Guillaume Lelarge , Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000003c8de80624869a50" 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-15_12,2024-10-15_01,2024-09-30_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003c8de80624869a50 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I removed 'program' from the OPTIONS keyword which resolved it, as suggested by Guillaume. On Tue, Oct 15, 2024 at 9:00=E2=80=AFAM vignesh kumar < vigneshkumar.venugopal@outlook.com> wrote: > 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 =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 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. > > > > -- > Guillaume. > --=20 *Samuel Stearns* Lead Database Administrator *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com [image: DAT] --0000000000003c8de80624869a50 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I removed 'program' from the OPTIONS keyword which= resolved it, as suggested by Guillaume.

On Tue, Oct 15, 2024 at 9:00=E2=80= =AFAM vignesh kumar <vigneshkumar.venugopal@outlook.com> wrote:
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 here

= Sent from Outlook for Android
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
=C2=A0
Hi,

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

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

2024-10-14 11:08:30.928 PDT [1177724] ERROR: =C2=A0conflicting or redu= ndant options
2024-10-14 11:08:30.928 PDT [1177724] 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),<= br> =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),<= br> =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 commonauthority cha= r(1),
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 contractauthority c= har(1),
=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 '= ;DISABLED', format 'csv', delimiter ',', program '&= #39;);

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 = documentation.

Would=C2=A0someone be able to give advice here, please?


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

You can't specify both filename and program. You have to choose on= e 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=
--0000000000003c8de80624869a50--