2012/6/11 Vibhor Kumar <vibhor.ku...@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 > >
