Foreign PostgreSQL server
От | Edson Carlos Ericksson Richter |
---|---|
Тема | Foreign PostgreSQL server |
Дата | |
Msg-id | 006f01cc74c1$91b59b50$b520d1f0$@com.br обсуждение исходный текст |
Ответы |
RES: Foreign PostgreSQL server
|
Список | 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 www.simkorp.com.br
В списке pgsql-general по дате отправления: