Foreign PostgreSQL server

From: "Edson Carlos Ericksson Richter" <richter(at)simkorp(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Foreign PostgreSQL server
Date: 2011-09-16 22:39:56
Message-ID: 006f01cc74c1$91b59b50$b520d1f0$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:

----------------------------------------------------------------------------
--
drop foreign data wrapper postgresql_fdw cascade;

create extension dblink;

CREATE FOREIGN DATA WRAPPER postgresql_fdw
VALIDATOR postgresql_fdw_validator
HANDLER postgresql_fdw_handler;

CREATE SERVER simfrete02 FOREIGN DATA WRAPPER pgsql OPTIONS (host
'127.0.0.1', dbname 'simfrete', port '5432');
----------------------------------------------------------------------------
---
And the errors are:
ERROR: function postgresql_fdw_handler() does not exists

********** Error **********

ERROR: function postgresql_fdw_handler() does not exists
SQL state: 42883

Can you point what I'm doing wrong?

Thanks & Regards,

Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796

www.simkorp.com.br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Carlos Ericksson Richter 2011-09-16 23:03:03 RES: Foreign PostgreSQL server
Previous Message Rich Shepard 2011-09-16 22:14:50 Re: Apparent Problem With NULL in Restoring pg_dump