Search Postgresql Archives

Foreign PostgreSQL server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux