| 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: | Whole Thread | Raw Message | 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 |