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

[Devrim G. <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