Menu
▾
▴
postgres-xc-bugs
|
From: Hitoshi H. <hem...@la...> - 2012-05-28 07:24:00
|
Hi, This is a dblink related error. ============================================================================ POSTGRES-XC BUG REPORT TEMPLATE ============================================================================ Your name : Hitoshi Hemmi Your email address : hem...@la... System Configuration: --------------------- Architecture : x86_64 Operating System : CentOS release 5.8 (Final) Postgres-XC version : Postgres-XC 1.0beta2 Compiler used : gcc 4.1.2 20080704 (Red Hat 4.1.2-52) Description of problems: ============================================== *** Look at the following session log. [postgres@coordinator1 ~]$ createdb local [postgres@coordinator1 ~]$ psql local psql (9.1beta2) Type "help" for help. local=# CREATE EXTENSION dblink ; ERROR: function "dblink_connect" already exists with same argument types ============================================== Thanks. -- Hitoshi HEMMI NTT Open Source Software Center hem...@la... (Please note that my address has changed.) Tel:(03)5860-5115 Fax:(03)5463-5490 |
|
From: Koichi S. <koi...@gm...> - 2012-05-28 08:56:50
|
Ouch! This will be fixed before V1.0 is out. Sorry for inconvenience. Regards; ---------- Koichi Suzuki 2012/5/28 Hitoshi HEMMI <hem...@la...>: > Hi, > > This is a dblink related error. > > ============================================================================ > POSTGRES-XC BUG REPORT TEMPLATE > ============================================================================ > > Your name : Hitoshi Hemmi > Your email address : hem...@la... > > > System Configuration: > --------------------- > Architecture : x86_64 > > Operating System : CentOS release 5.8 (Final) > > Postgres-XC version : Postgres-XC 1.0beta2 > > Compiler used : gcc 4.1.2 20080704 (Red Hat 4.1.2-52) > > > Description of problems: > ============================================== > *** Look at the following session log. > > [postgres@coordinator1 ~]$ createdb local > [postgres@coordinator1 ~]$ psql local > psql (9.1beta2) > Type "help" for help. > > local=# CREATE EXTENSION dblink ; > ERROR: function "dblink_connect" already exists with same argument types > > ============================================== > > Thanks. > > -- > Hitoshi HEMMI > NTT Open Source Software Center > hem...@la... > (Please note that my address has changed.) > Tel:(03)5860-5115 > Fax:(03)5463-5490 > > > ------------------------------------------------------------------------------ > 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 |
|
From: Koichi S. <koi...@gm...> - 2012-05-28 09:01:26
|
Sorry, I meant this response for pgxc_clean. ---------- Koichi Suzuki 2012/5/28 Koichi Suzuki <koi...@gm...>: > Ouch! This will be fixed before V1.0 is out. > > Sorry for inconvenience. > > Regards; > ---------- > Koichi Suzuki > > > 2012/5/28 Hitoshi HEMMI <hem...@la...>: >> Hi, >> >> This is a dblink related error. >> >> ============================================================================ >> POSTGRES-XC BUG REPORT TEMPLATE >> ============================================================================ >> >> Your name : Hitoshi Hemmi >> Your email address : hem...@la... >> >> >> System Configuration: >> --------------------- >> Architecture : x86_64 >> >> Operating System : CentOS release 5.8 (Final) >> >> Postgres-XC version : Postgres-XC 1.0beta2 >> >> Compiler used : gcc 4.1.2 20080704 (Red Hat 4.1.2-52) >> >> >> Description of problems: >> ============================================== >> *** Look at the following session log. >> >> [postgres@coordinator1 ~]$ createdb local >> [postgres@coordinator1 ~]$ psql local >> psql (9.1beta2) >> Type "help" for help. >> >> local=# CREATE EXTENSION dblink ; >> ERROR: function "dblink_connect" already exists with same argument types >> >> ============================================== >> >> Thanks. >> >> -- >> Hitoshi HEMMI >> NTT Open Source Software Center >> hem...@la... >> (Please note that my address has changed.) >> Tel:(03)5860-5115 >> Fax:(03)5463-5490 >> >> >> ------------------------------------------------------------------------------ >> 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 |
|
From: Michael P. <mic...@gm...> - 2012-05-28 23:28:37
|
I am not a specialist of extensions. But I can reproduce exactly the same issue with vanilla PostgreSQL, so this is not a bug. On Mon, May 28, 2012 at 4:23 PM, Hitoshi HEMMI <hem...@la...>wrote: > Hi, > > This is a dblink related error. > > > ============================================================================ > POSTGRES-XC BUG REPORT TEMPLATE > > ============================================================================ > > Your name : Hitoshi Hemmi > Your email address : hem...@la... > > > System Configuration: > --------------------- > Architecture : x86_64 > > Operating System : CentOS release 5.8 (Final) > > Postgres-XC version : Postgres-XC 1.0beta2 > > Compiler used : gcc 4.1.2 20080704 (Red Hat 4.1.2-52) > > > Description of problems: > ============================================== > *** Look at the following session log. > > [postgres@coordinator1 ~]$ createdb local > [postgres@coordinator1 ~]$ psql local > psql (9.1beta2) > Type "help" for help. > > local=# CREATE EXTENSION dblink ; > ERROR: function "dblink_connect" already exists with same argument types > > ============================================== > > Thanks. > > -- > Hitoshi HEMMI > NTT Open Source Software Center > hem...@la... > (Please note that my address has changed.) > Tel:(03)5860-5115 > Fax:(03)5463-5490 > > > > ------------------------------------------------------------------------------ > 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 |
|
From: Devrim G. <de...@gu...> - 2012-05-28 23:54:38
Attachments:
signature.asc
|
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
|
|
From: Koichi S. <koi...@gm...> - 2012-05-29 00:31:15
|
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
>
|
|
From: Michael P. <mic...@gm...> - 2012-05-29 01:12:47
|
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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X