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.
Im 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
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 |