From: | Clodoaldo Neto <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> |
---|---|
To: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
Cc: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dblink.sql not found |
Date: | 2012-06-11 15:28:39 |
Message-ID: | CA+Z73LF+=rKg0svv02rFrkUZzBjyCTxCOy=3Dw-BzeNQztMA_Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2012/6/11 Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vibhor Kumar | 2012-06-11 15:46:56 | Re: dblink.sql not found |
Previous Message | Clodoaldo Neto | 2012-06-11 15:17:22 | dblink.sql not found |