RES: RES: RES: [GENERAL] Foreign PostgreSQL server

2011-09-17 Thread Edson Carlos Ericksson Richter
laver Enviada em: sábado, 17 de setembro de 2011 14:30 Para: pgsql-general@postgresql.org Cc: Edson Carlos Ericksson Richter Assunto: Re: RES: RES: [GENERAL] Foreign PostgreSQL server On Saturday, September 17, 2011 5:22:35 am Edson Carlos Ericksson Richter wrote: > Thanks Adrian, I really m

Re: RES: RES: [GENERAL] Foreign PostgreSQL server

2011-09-17 Thread Adrian Klaver
On Saturday, September 17, 2011 5:22:35 am Edson Carlos Ericksson Richter wrote: > Thanks Adrian, I really miss that part... > Anyway, if I try to declare a handler like > > CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_validator > HANDLER postgresql_fdw_handler; > > (as found o

RES: RES: [GENERAL] Foreign PostgreSQL server

2011-09-17 Thread Edson Carlos Ericksson Richter
: Re: RES: [GENERAL] Foreign PostgreSQL server On Friday, September 16, 2011 4:03:03 pm Edson Carlos Ericksson Richter wrote: > Ok, managed to get the first part working: > > --- > create extension dblink; > CREA

Re: RES: [GENERAL] Foreign PostgreSQL server

2011-09-16 Thread Adrian Klaver
On Friday, September 16, 2011 4:03:03 pm Edson Carlos Ericksson Richter wrote: > Ok, managed to get the first part working: > > --- > create extension dblink; > CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_v

RES: [GENERAL] Foreign PostgreSQL server

2011-09-16 Thread Edson Carlos Ericksson Richter
Ok, managed to get the first part working: --- create extension dblink; CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_validator; CREATE SERVER simfrete02 FOREIGN DATA WRAPPER postgresql OPTIONS (host '127.0.0

[GENERAL] Foreign PostgreSQL server

2011-09-16 Thread Edson Carlos Ericksson Richter
Hi! Sorry if this was already asked. My platform: Win7, PostgreSQL 9.1 64bit installed using EnterpriseDB package. I’m trying to setup a bunch of foreign PostgreSQL servers, but whenever I execute the script below, I get errors: --