Thread: dblink.sql not found

dblink.sql not found

From

Clodoaldo Neto

Date:

11 June 2012, 15:17:38

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

Re: dblink.sql not found

From

Vibhor Kumar

Date:

11 June 2012, 15:22:30

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;

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

Re: dblink.sql not found

From

Clodoaldo Neto

Date:

11 June 2012, 15:28:55

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

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