Re: [Postgres-xc-bugs] CREATE EXTENSION dblink

[Michael P. <mic...@gm...>]

Issue is fixed with commit c23f72f.
https://github.com/postgres-xc/postgres-xc/commit/c23f72f3d3853a3c3b6f3c855bd9946070100b92
You need to install extension modules on all the install folders of all the
servers involved in cluster to create the extensions or it will fail.

On Tue, May 29, 2012 at 9:31 AM, Koichi Suzuki <koi...@gm...> wrote:

> The issue in XC looks different.   Please see the following:
>
> koichi=# \dx
>                  List of installed extensions
>  Name   | Version |   Schema   |         Description
> ---------+---------+------------+------------------------------
>  plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
> (1 row)
>
> koichi=# create extension dblink;
> ERROR:  function "dblink_connect" already exists with same argument types
> koichi=#
>
> Regards;
> ----------
> Koichi Suzuki
>
>
> 2012/5/29 Devrim GÜNDÜZ <de...@gu...>:
> >
> > On Tue, 2012-05-29 at 08:28 +0900, Michael Paquier wrote:
> >> But I can reproduce exactly the same issue with vanilla PostgreSQL, so
> >> this is not a bug.
> >
> > So it means you probably have already dblink extension installed. See
> > output of \dx. I cannot reproduce it with community PostgreSQL:
> >
> > regression=> \dx
> >                 List of installed extensions
> >  Name   | Version |   Schema   |         Description
> > ---------+---------+------------+------------------------------
> >  plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
> > (1 row)
> >
> > regression=# CREATE EXTENSION dblink ;
> > CREATE EXTENSION
> >
> > regression=# \dx
> >                                 List of installed extensions
> >  Name   | Version |   Schema   |                         Description
> >
> ---------+---------+------------+--------------------------------------------------------------
> >  dblink  | 1.0     | public     | connect to other PostgreSQL databases
> from within a database
> >  plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
> > (2 rows)
> >
> > Regards,
> > --
> > Devrim GÜNDÜZ
> > Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> > Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> > http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
> >
> >
> ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond. Discussions
> > will include endpoint security, mobile security and the latest in malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > _______________________________________________
> > Postgres-xc-bugs mailing list
> > Pos...@li...
> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs
> >
>



-- 
Michael Paquier
http://michael.otacoo.com