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

[Koichi S. <koi...@gm...>]

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
>