From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
---|---|
To: | clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com |
Cc: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dblink.sql not found |
Date: | 2012-06-11 15:46:56 |
Message-ID: | 72365E19-C3E2-4F9F-BC94-F6D0AFB40775@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2012-06-11 16:21:33 | Re: Postgres Installation Password |
Previous Message | Clodoaldo Neto | 2012-06-11 15:28:39 | Re: dblink.sql not found |