[GENERAL] Can't create plpython language

2013-07-04 Thread guxiaobo1982
Hi, I am running PostgreSQL 9.2.4.1 (from EnterpriseDB) on CENTOS 5.9 X64 server, I got the following errors when trying to create the python language handler, can you help with this, thanks in advance. [postgres@lix ~]$ psql Password: psql.bin (9.2.4) Type "help" for help. No entry for t

[GENERAL] ?????? [GENERAL] Can't create plpython language

2013-07-04 Thread guxiaobo1982
NERAL] Can't create plpython language try the postgresql official rpm package for centos 5?? http://yum.postgresql.org/9.2/redhat/rhel-5-x86_64/pgdg-centos92-9.2-6.noarch.rpm or build your own from source. Jov blog: http:amutu.com/blog 2013/7/5 Michael Paquier On Thu, Jul 4, 201

Reply: [GENERAL] Can't create plpython language

2013-07-05 Thread guxiaobo1982
thon3": No such file or directory postgres=# create language plpython2u; CREATE LANGUAGE postgres=# -- Original -- Sender: "Jov"; Send time: Friday, Jul 5, 2013 7:59 AM To: "Michael Paquier"; Cc: "guxiaobo1982"; &qu

[GENERAL] postgresql93-devel-9.3beta2-1PGDG.rhel5.x86_64 missed pg_config

2013-07-05 Thread guxiaobo1982
Hi, I installed postgreSQL 9.3 beta 2 from http://yum.postgresql.org/repopackages.php#pg92 following http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html But I cann't find pg_config, is this a bug? Xiaobo Gu

[GENERAL] How to build postgresql 9.3 beta2 from source with plpython3u handler and postgres_fdw extensions.

2013-07-05 Thread guxiaobo1982
Hi, I use the following commands to build PostgreSQL9.3 from source, but plpython3u and postgres_fdw are missed in the result, can you help with this. ./configure PYTHON='/opt/python32/bin/python3' --prefix=/opt/PostgreSQL/93b2src --with-python make make install export PATH=/opt/PostgreSQL/

Re: [GENERAL] How to build postgresql 9.3 beta2 from source withplpython3u handler and postgres_fdw extensions.

2013-07-05 Thread guxiaobo1982
"; Date: Jul 5, 2013 To: "guxiaobo1982"; Cc: "pgsql-general"; Subject: Re: [GENERAL] How to build postgresql 9.3 beta2 from source withplpython3u handler and postgres_fdw extensions. On 07/05/2013 03:31 AM, guxiaobo1982 wrote: > Hi, > > I use the following

Re: [GENERAL] How to build postgresql 9.3 beta2 from source withplpython3u handler and postgres_fdw extensions.

2013-07-05 Thread guxiaobo1982
And what about postgres_fdw? -- Original -- From: "Adrian Klaver"; Date: Jul 5, 2013 To: "guxiaobo1982"; Cc: "pgsql-general"; Subject: Re: [GENERAL] How to build postgresql 9.3 beta2 from source withplpython3u handler and

[GENERAL] Reply: [GENERAL] ?????? [GENERAL] Can't create plpython language

2013-07-09 Thread guxiaobo1982
Xiaobo Gu -- Original -- Sender: "Raghavendra"; Send time: Tuesday, Jul 9, 2013 8:00 PM To: "guxiaobo1982"; Cc: "Jov"; "Michael Paquier"; "pgsql-general"; Subject: Re: [GENERAL] ?? [GENERAL] Can't create plpython lang

[GENERAL] Can we specify transaction level when connectting to external postgresql server via postgres_fdw

2013-07-10 Thread guxiaobo1982
Hi, We are try to connect to Greenplum database from PostgreSQL 9.3 beta2 via postgres_fdw, but the Greenplum Database does not support REPEATABLE READ transactions, can we specify other isolation leves? Regards, Xiaobo Gu

Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

2013-07-15 Thread guxiaobo1982
---- Sender: "Jov"; Send time: Thursday, Jul 11, 2013 2:06 PM To: "guxiaobo1982"; Cc: "pgsql-general"; Subject: Re: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw from the doc: The remote

[GENERAL] Re: Reply: [GENERAL] ?????? [GENERAL] Can't create plpython language

2013-07-15 Thread guxiaobo1982
It works with ActivePython 3.2.2.3, but not ActivePython 2.7.2.5. -- Original -- From: "Raghavendra"; Date: Jul 11, 2013 To: "guxiaobo1982"; Cc: "Jov"; "Michael Paquier"; "pgsql-general"; "Asif

Reply: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

2013-07-15 Thread guxiaobo1982
Greeplum is based on 8.2.15, so we can only use the read-only option. -- Original -- Sender: "Tom Lane"; Send time: Tuesday, Jul 16, 2013 1:57 PM To: "guxiaobo1982"; Cc: "Jov"; "pgsql-general"; Subject: Re: Reply: [G

[GENERAL] Reply: Reply: [GENERAL] ?????? [GENERAL] Can't create plpython language

2013-07-17 Thread guxiaobo1982
PATH=$PYTHONHOME/lib:$LD_LIBRARY_PATH -- Original -- Sender: "Raghavendra"; Send time: Tuesday, Jul 16, 2013 4:53 PM To: "guxiaobo1982"; Cc: "Jov"; "Michael Paquier"; "pgsql-general"; "Asif Naeem"; Sub

Re: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

2013-07-19 Thread guxiaobo1982
Xiaobo Gu -- Original -- From: "guxiaobo1982"; Date: Jul 16, 2013 To: "Tom Lane"; Cc: "Jov"; "pgsql-general"; Subject: Reply: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_

Reply: [GENERAL] Can we specify transaction level

2013-07-19 Thread guxiaobo1982
what does a wrapper function mean, count is a standard function in Greenplum, or how to creat the wrapper function. regards On Fri, Jul 19, 2013 at 7:47 AM, guxiaobo1982 wrote: There is another situation, We have a demo table with about 1700 rows, the "select count(1)

Reply: [GENERAL] Can we specify transaction level

2013-07-19 Thread guxiaobo1982
I wil test next week, but the document of postgres_fdw says it is smart enough to push executing into the external server, I wander is this a bug or a version compability problem. ---原始邮件--- 在 2013年07月20日 10:05:02 "bricklen" 写道: On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982 wrote: