Foreign PostgreSQL server - Mailing list 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