Re: dblink.sql not found

[Clodoaldo Neto <clodoaldo.pinto.neto@xxxxxxxxx>]

2012/6/11 Vibhor Kumar <vibhor.kumar@xxxxxxxxxxxxxxxx>

On Jun 11, 2012, at 11:17 AM, Clodoaldo Neto wrote:

> I have postgresql91-contrib installed in Centos 6:
>
> # yum list installed postgresql91-contrib
> ...
> Installed Packages
> postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91
>
> But when I try to use it I get the error:
>
> ERROR:  function dblink(text, text) does not exist
> LINE 2: from dblink(
>              ^
> HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
>
> Also I can't find dblink.sql:
>
> # find / -name dblink.sql
>
> What am I missing?
>
> Regards, Clodoaldo

After installing the contrib module you have to execute following command in Database:
CREATE EXTENSION dblink;

 

That worked!

Thank You, Clodoaldo
 

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com