Re: Foreign Data Wrapper behavior?

Ah, thanks for that On Fri, Oct 11, 2024 at 5:59 PM Adrian Klaver wrote: > On 10/11/24 04:08, Koen De Groote wrote: > > In the release notes for postgres 17 I'm reading: > > > > > The PostgreSQL foreign data wrapper (postgres_fdw), used to execute > > que

Re: Foreign Data Wrapper behavior?

On 10/11/24 04:08, Koen De Groote wrote: In the release notes for postgres 17 I'm reading: > The PostgreSQL foreign data wrapper (postgres_fdw), used to execute queries on remote PostgreSQL instances, can now push EXISTS and IN subqueries to the remote server for more efficient pr

Foreign Data Wrapper behavior?

In the release notes for postgres 17 I'm reading: > The PostgreSQL foreign data wrapper (postgres_fdw), used to execute queries on remote PostgreSQL instances, can now push EXISTS and IN subqueries to the remote server for more efficient processing. I'm confused as to what this me

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

d-x86_64 is listed more than once in the >> configuration* >> >> *Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the >> configuration* >> >> *Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the >> configuration* >> &g

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

> configuration* > > *No package llvm-toolset-7 available.* > > *Error: Nothing to do* > > *[root@hostip tds_fdw-2.0.3]#* > > *[root@hostip tds_fdw-2.0.3]#* > > > > *From:* Muhammad Imtiaz > *Sent:* Tuesday, May 28, 2024 11:43 PM > *To:* Ian Lawren

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

@lists.postgresql.org Subject: {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Hi , You need to install the LLVM toolset. 1)Check that if it is installed or not : yum list installed | grep llvm-toolset 2)If it is not installed, you can inst

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Lawrence Barwick wrote: > 2024年5月29日(水) 6:10 Sumit Kochar : > > > > Installation of Foreign data Wrapper on EDB Postgres to connect to SQL > server database is not working. > > > > > > > > https://github.com/tds-fdw/tds_fdw/issues/357 > > > > &

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

2024年5月29日(水) 6:10 Sumit Kochar : > > Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server > database is not working. > > > > https://github.com/tds-fdw/tds_fdw/issues/357 > > > > Please advise if this has been encountered or a workar

tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server database is not working. https://github.com/tds-fdw/tds_fdw/issues/357 Please advise if this has been encountered or a workaround is available. OS: NAME="Oracle Linux Server" VERSION="7.9" ID=

delta.io foreign data wrapper

Hi, Postgres already has a foreign data wrapper (FDW) for external tables stored in parquet format on S3 https://www.postgresql.org/about/news/parquet-s3-fdw-030-released-2474/. Delta https://delta.io/ is an evolution of parquet to a more cloud-friendly/ACID table format also allowing for

Re: About foreign data wrapper

2022年10月17日(月) 16:36 Rama Krishnan : > > Hi all, > > What Is the difference between dblink and foreign data wrapper? Basically, dblink enables you to execute individual queries on a remote PostgreSQL server via a function and use the results in a local query e.g.: SELECT *

About foreign data wrapper

Hi all, What Is the difference between dblink and foreign data wrapper? Thanks Ramakrishnan

Can one call pg_total_relation_size over foreign data wrapper?

Hi Team, Can one call pg_total_relation_size over foreign data wrapper? Problem statement - I need to connect to 100s of databases over foreign data wrapper to collect the size of each table. As a part of that I have to use pg_total_relation_size over foreign data wrappers. Alternatively, I

Re: help implementing OGR Postgres foreign data wrapper

: Tuesday, October 5, 2021 20:57 To: Brent Wood Cc: pgsql-general@lists.postgresql.org Subject: Re: help implementing OGR Postgres foreign data wrapper Hi Brent, not sure why, but it is working for me using ogrinfo: ~ $ ogrinfo https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services

Re: help implementing OGR Postgres foreign data wrapper

Hi Brent, not sure why, but it is working for me using ogrinfo: ~ $ ogrinfo https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer\?SERVICE\=WFS\&REQUEST\=GetCapabilities INFO: Open of ` https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_C

help implementing OGR Postgres foreign data wrapper

Hi, Apologies, this not strictly a Postgres question, but Postgres is so fundamental to what I'm trying to do and this list is generally so helpful, so here I go... I'm using FDW's to create virtual tables providing access to data from external data sources. This is working well for data in ot

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

On Mon, 2021-09-20 at 15:41 +0200, Magnus Hagander wrote: > Just as a note, with PostgreSQL 14 the FDW APIs allow batch insert. It > should be possible to update oracle_fdw to take advantage of that as > well, right? Yes. The exercise is more complicated in Oracle, because they don't support mult

SV: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

-Oprindelig meddelelse- >Fra: Laurenz Albe >Sendt: 20. september 2021 15:18 >Til: Niels Jespersen ; pgsql-gene...@postgresql.org >Emne: Re: Possibilities for optimizing inserts across oracle_fdw foreign data >wrapper > >On Sun, 2021-09-19 at 10:28 +, Niels Jespe

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

On Mon, Sep 20, 2021 at 3:18 PM Laurenz Albe wrote: > > On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote: > > We are often using the oracle_fdw to transfer data between Postgres > > (version 11+) and Oracle (version 18+). It works great. > > > > However I have a task at hand that requires

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote: > We are often using the oracle_fdw to transfer data between Postgres (version > 11+) and Oracle (version 18+). It works great. >   > However I have a task at hand that requires inserting a few billion rows in > an Oracle table from a Post

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

On 9/19/21 06:28, Niels Jespersen wrote: Hello all We are often using the oracle_fdw to transfer data between Postgres (version 11+) and Oracle (version 18+). It works great. However I have a task at hand that requires inserting a few billion rows in an Oracle table from a Postgres query.

Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

Hello all We are often using the oracle_fdw to transfer data between Postgres (version 11+) and Oracle (version 18+). It works great. However I have a task at hand that requires inserting a few billion rows in an Oracle table from a Postgres query. insert into t_ora (a,b,c) select a,b,c from t

Re: Foreign Data Wrapper Handler

On 11/9/20 9:21 AM, Susan Hurst wrote: Thanks for the detailed instructions, Laurenz! "The foreign server encapsulates the connection string to access a remote PostgreSQL database.  Define one per remote database you want to access." Where do I define "one per remote database"?.in pg_hba.co

Re: Foreign Data Wrapper Handler

On Mon, 2020-11-09 at 11:21 -0600, Susan Hurst wrote: > "The foreign server encapsulates the connection string to access a remote > PostgreSQL database. Define one per remote database you want to access." > > Where do I define "one per remote database"?.in pg_hba.conf? No, in SQL: CREATE

Re: Foreign Data Wrapper Handler

reign db, I need a different name for each connection. I cannot name each fdw postgres_fdw. I would like to name the fdws something like: dbname_to_foreigndbname. For example, here are 2 possible fdws: create foreign data wrapper stp_to_geo; create foreign data wrapper stp_to_metrics; That syntax creat

Re: Foreign Data Wrapper Handler

dbname. > > For example, here are 2 possible fdws: > > create foreign data wrapper stp_to_geo; > create foreign data wrapper stp_to_metrics; > > That syntax creates the fdw and I can create user mappings but I cannot > import any foreign schemas into my database. The error

Re: Foreign Data Wrapper Handler

: create foreign data wrapper stp_to_geo; create foreign data wrapper stp_to_metrics; Aren't you looking for?: https://www.postgresql.org/docs/12/sql-createserver.html " A foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external dat

Re: Foreign Data Wrapper Handler

database so if I want to connect to more than one foreign db, I need a different name for each connection. I cannot name each fdw postgres_fdw. I would like to name the fdws something like: dbname_to_foreigndbname. For example, here are 2 possible fdws: create foreign data wrapper stp_to_geo; create

Re: Foreign Data Wrapper Handler

On 11/7/20 12:44 PM, Susan Hurst wrote: Can anyone recommend a good online resource for learning how to set up a foreign data wrapper using a custom fdw name?  It seems the trick is to use a handler to make it work but so far the search results have been elusive for creating a fdw with a

Foreign Data Wrapper Handler

Can anyone recommend a good online resource for learning how to set up a foreign data wrapper using a custom fdw name? It seems the trick is to use a handler to make it work but so far the search results have been elusive for creating a fdw with a successful outcome. I'm using '

Re: Keeping state in a foreign data wrapper

On Mon, 2020-08-03 at 19:23 +0300, Stelios Sfakianakis wrote: > I am trying to implement a FDW in Postgres for accessing a web api and I > would > like to keep information like for example the total number of requests > submiited. > Ideally these data should be kept “per-user” and of course wi

Re: Keeping state in a foreign data wrapper

On 2020/08/04 19:21, Stelios Sfakianakis wrote: > Thank you again, I have another question in order to make sure I have a clear understanding: > > >> On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote: >> >> The hash table is specific to each running backend so will only be >> accessed by that

Re: Keeping state in a foreign data wrapper

On 2020/08/04 19:21, Stelios Sfakianakis wrote: > Thank you again, I have another question in order to make sure I have a clear understanding: > > >> On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote: >> >> The hash table is specific to each running backend so will only be >> accessed by that

Re: Keeping state in a foreign data wrapper

Thank you again, I have another question in order to make sure I have a clear understanding: > On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote: > > The hash table is specific to each running backend so will only be > accessed by that process. > > Pre-loading a shared library just gives th

Re: Keeping state in a foreign data wrapper

2020年8月4日(火) 14:54 Stelios Sfakianakis : > On 4 Aug 2020, at 06:25, Ian Lawrence Barwick wrote: > > 2020年8月4日(火) 1:24 Stelios Sfakianakis : > > Hi, > >>> I am trying to implement a FDW in Postgres for accessing a web api and I >>> would like to keep information like for example the total number

Re: Keeping state in a foreign data wrapper

Thank you Ian for the prompt reply! I will certainly have a look at pg_stat_statements I also came across mysql_fdw (https://github.com/EnterpriseDB/mysql_fdw ) that features a connection pool shared across queries. It uses a hash table with the server

Re: Keeping state in a foreign data wrapper

2020年8月4日(火) 1:24 Stelios Sfakianakis : > > Hi, > > I am trying to implement a FDW in Postgres for accessing a web api and I > would like to keep information like for example the total number of requests > submiited. Ideally these data should be kept “per-user” and of course with > the proper l

Keeping state in a foreign data wrapper

Hi, I am trying to implement a FDW in Postgres for accessing a web api and I would like to keep information like for example the total number of requests submiited. Ideally these data should be kept “per-user” and of course with the proper locking to eliminate race conditions. So the question

Unexpected plan width with foreign data wrapper

, test is considered failed. Major source of test failures is width estimation in query plan explaination. For example, for following statements: CREATE EXTENSION multicorn; CREATE server multicorn_srv foreign data wrapper multicorn options ( wrapper

Re: Postgrest over foreign data wrapper

Ah. I didn't realize Postgrest was something, rather than just a typo. An fkey to a foreign table is not supported. Related- https://dba.stackexchange.com/questions/138591/foreign-key-references-constraint-on-postgresql-foreign-data-wrapper *Michael Lewis | Software Engineer* *Entrat

Re: Postgrest over foreign data wrapper

t you will get an index? * * * * *Michael Lewis  | Software Engineer* *Entrata** * *c:**619.370.8697 * On Wed, Feb 13, 2019 at 2:04 PM adrien ruffie <mailto:adriennolar...@hotmail.fr>> wrote: we have a tricky problem with my colleague. We have to database db1 and db2

Re: Postgrest over foreign data wrapper

a* *c: **619.370.8697 <619-370-8697>* On Wed, Feb 13, 2019 at 2:04 PM adrien ruffie wrote: > we have a tricky problem with my colleague. >> We have to database db1 and db2 linked by a foreign data wrapper >> connection. >> 1 table "contractline" in db1 and "contr

Re: Postgrest over foreign data wrapper

On 2/13/19 1:04 PM, adrien ruffie wrote: we have a tricky problem with my colleague. We have to database db1 and db2 linked by a foreign data wrapper connection. 1 table "contractline" in db1 and "contract" in db2. We use postgrest in order to request d

Postgrest over foreign data wrapper

we have a tricky problem with my colleague. We have to database db1 and db2 linked by a foreign data wrapper connection. 1 table "contractline" in db1 and "contract" in db2. We use postgrest in order to request db2 via CURL. But we want to add a link between previous table

Re: Analyze plan of foreign data wrapper

I read it many times but I'am not entirely familiar with concepts of range table and I'am not sure to fully understant all implications. For now I have a workaround by parsing only plan's target list and by checking if resorigtbl is equal to oid of my table. The main drawback is that I can't detect

Re: Analyze plan of foreign data wrapper

Mathieu PUJOL wrote: > I understand that I should also use varno to check which table is referenced > by varattno. In case of Join, aggregation, etc. Sometimes I get a number or > INNER_VAR or OUTER_VAR. > I am lost on how i could resolve this. > I understand that OUTER_VAR/INNER_VAR are related

Re: Analyze plan of foreign data wrapper

related to left plan and inner to right plan ? In this case varattno is index of target list of subplan ? When varno is an index how to retrieve table info ? Regards Mathieu Le jeu. 28 juin 2018 à 23:17, Laurenz Albe a écrit : > Mathieu PUJOL wrote: > > I'am writing a foreign da

Re: Analyze plan of foreign data wrapper

Mathieu PUJOL wrote: > I'am writing a foreign data wrapper. To avoid returning data for a column > that is not used, I parse 'targetlist' and 'qual' of the Plan. > I'am able to find Var nodes but I can't figure out how i could now if this > node

Analyze plan of foreign data wrapper

Hello! I'am writing a foreign data wrapper. To avoid returning data for a column that is not used, I parse 'targetlist' and 'qual' of the Plan. I'am able to find Var nodes but I can't figure out how i could now if this node is related to a column my foreign tabl

Re: Postgres Foreign Data Wrapper and DB2 LUW

Hello, not sure that there is a dedicated fdw for DB2 LUW, but you may try one of ODBC_FDW (and maybe JDBC_FDW) as decribed here: https://wiki.postgresql.org/wiki/Foreign_data_wrappers Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Postgres Foreign Data Wrapper and DB2 LUW

I require a $7500 advance. On Tue, Mar 27, 2018, 11:15 AM Rakesh Kumar wrote: > Is there a web page describing how to set up a PG FDW to talk to DB2 LUW > ver 10.5 ? > > > Thanks. > >

Postgres Foreign Data Wrapper and DB2 LUW

Is there a web page describing how to set up a PG FDW to talk to DB2 LUW ver 10.5 ? Thanks.

Re: Foreign Data Wrapper

On Thu, Dec 21, 2017 at 12:24:25PM +, Virendra Shaktawat - Quipment India wrote: > [Quipment Logo] > I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. > Foreign table has been created with data. unfortunately I am unable to > perform DML operation

Re: Foreign Data Wrapper

Le 21 déc. 2017 à 13:24, Virendra Shaktawat - Quipment India écrivait : > Quipment Logo > > Hello , > > > > I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. > Foreign table has been created with data. unfortunately I am unable to perform >

Re: Foreign Data Wrapper

On 12/21/2017 5:14 AM, Virendra Shaktawat - Quipment India wrote: odbc_fdw please don't top post, and please don't use graphics and HTML in your email, this is a text based mailling list adhering to bottom/interleaved posting standards. While I'm not directly familiar with odbc_fdw, I sus

RE: Foreign Data Wrapper

ment India Cc: pgsql-gene...@postgresql.org Subject: Re: Foreign Data Wrapper Which FDW? On Thu, Dec 21, 2017 at 5:54 PM, Virendra Shaktawat - Quipment India mailto:virendra.shakta...@quipment.nl>> wrote: [Quipment Logo] Hello , I have stuck at foreign data wrapper. I am accessing the fo

Re: Foreign Data Wrapper

Which FDW? On Thu, Dec 21, 2017 at 5:54 PM, Virendra Shaktawat - Quipment India < virendra.shakta...@quipment.nl> wrote: > [image: Quipment Logo] > > Hello , > > > > I have stuck at foreign data wrapper. I am accessing the form MS Sql > Server. Foreign ta

Foreign Data Wrapper

[Quipment Logo] Hello , I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. Foreign table has been created with data. unfortunately I am unable to perform DML operation like insert, update and delete on foreign table. Whenever I tried to perform DML operation on