Re: Foreign Data Wrapper behavior?

2024-10-12 Thread Koen De Groote
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 > > queries on remote PostgreSQL instances, can

Re: Foreign Data Wrapper behavior?

2024-10-11 Thread Adrian Klaver
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 processing.

Re: Foreign Data Wrapper Handler

2020-11-09 Thread Adrian Klaver
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

2020-11-09 Thread Laurenz Albe
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

2020-11-09 Thread Susan Hurst
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.conf? ---

Re: Foreign Data Wrapper Handler

2020-11-09 Thread Laurenz Albe
On Sun, 2020-11-08 at 13:09 -0600, Susan Hurst wrote: > The first pass thru https://www.postgresql.org/docs/12/fdwhandler.html > does not tell me what I think I need to know, but I will digest this > more thoroughly. Maybe I need to understand more of the lingo re: > foreign data wrappers. I do

Re: Foreign Data Wrapper Handler

2020-11-08 Thread Adrian Klaver
On 11/8/20 11:09 AM, Susan Hurst wrote: The first pass thru https://www.postgresql.org/docs/12/fdwhandler.html does not tell me what I think I need to know, but I will digest this more thoroughly. Maybe I need to understand more of the lingo re: foreign data wrappers. I do understand that all f

Re: Foreign Data Wrapper Handler

2020-11-08 Thread Susan Hurst
The first pass thru https://www.postgresql.org/docs/12/fdwhandler.html does not tell me what I think I need to know, but I will digest this more thoroughly. Maybe I need to understand more of the lingo re: foreign data wrappers. I do understand that all fdw names must be unique within a databas

Re: Foreign Data Wrapper Handler

2020-11-07 Thread Adrian Klaver
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 succes

Re: Foreign Data Wrapper

2017-12-21 Thread Michael Paquier
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 like insert, upda

Re: Foreign Data Wrapper

2017-12-21 Thread Nicolas Paris
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 > DML operation like insert,

Re: Foreign Data Wrapper

2017-12-21 Thread John R Pierce
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

2017-12-21 Thread Virendra Shaktawat - Quipment India
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

2017-12-21 Thread Atri Sharma
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 table has been created with data. unfortun