Re: [GENERAL] new instance of postgres on windows

2013-07-19 Thread Thomas Kellerer
John R Pierce, 18.07.2013 21:20: If you want to install a completely new instance, just put it into a different directory, and given the service a different name. Newer Postgres versions don't need a dedicated Windows user account any more. I usually don't use the installer any more, but

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

2013-07-19 Thread Raghavendra
Foremost, its interesting, why your replies populate as distinct thread rather than of continuing one. (I may be incorrect, are you choosing forward option while replying, no ?). Request to hold the continuity of the post instead of different chunks for each reply. :) On Thu, Jul 18, 2013 at

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

2013-07-19 Thread John R Pierce
On 7/19/2013 12:12 AM, Raghavendra wrote: ... its interesting, why your replies populate as distinct thread rather than of continuing one the mailer they are using isn't generating 'In-Reply-To' and/or 'References' headers. -- john r pierce 37N 122W

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

2013-07-19 Thread Raghavendra
On Fri, Jul 19, 2013 at 1:30 PM, John R Pierce pie...@hogranch.com wrote: On 7/19/2013 12:12 AM, Raghavendra wrote: ... its interesting, why your replies populate as distinct thread rather than of continuing one the mailer they are using isn't generating 'In-Reply-To' and/or 'References'

Re: [GENERAL] Best Postgresql books

2013-07-19 Thread Pedro Costa
Thanks Steven Em 18-07-2013 23:20, Steven Schlansker escreveu: PostgreSQL 9.0 High Performance: http://www.amazon.com/books/dp/184951030X On Jul 18, 2013, at 3:11 PM, Pedro Costa pedrocostaa...@sapo.pt wrote: Hi guys, Can anyone tell me the best books about postgresql? Specialy about

Re: [GENERAL] FW: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure

2013-07-19 Thread George Weaver
From: Stephen Brearley To: pgsql-general@postgresql.org Sent: Wednesday, July 17, 2013 5:41 AM Subject: [GENERAL] FW: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure snip The Problem On re-installing Postgres, I have not been able to get it to work. During

Re: [GENERAL] Hot Standby and Foreign Tables

2013-07-19 Thread Tim Kane
Brilliant. Thanks Michael. That looks great. On Thu, Jul 18, 2013 at 11:54 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Thu, Jul 18, 2013 at 11:15 PM, Tim Kane tim.k...@gmail.com wrote: Hi all, I'm currently playing a few ideas out in my head and wanted to see if this

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

2013-07-19 Thread guxiaobo1982
There is another situation, We have a demo table with about 1700 rows, the select count(1) from demotable statement finishes with-in 3 seconds when executed directlly against the Greenplum database,but it takes about 230 seconds to finish when executed via postgres_fdw inside

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

2013-07-19 Thread bricklen
On Fri, Jul 19, 2013 at 7:47 AM, guxiaobo1982 guxiaobo1...@qq.com wrote: There is another situation, We have a demo table with about 1700 rows, the select count(1) from demotable statement finishes with-in 3 seconds when executed directlly against the Greenplum database,but it takes

[GENERAL] Insert result does not match record count

2013-07-19 Thread Natalie Wenz
Hi all, I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario: insert into newtable select data from oldtable where proc_date = x and proc_date y; INSERT 0 78551642 select count(*) from newtable where proc_date = x and proc_date y; count

Re: [GENERAL] Insert result does not match record count

2013-07-19 Thread Tom Lane
Natalie Wenz nataliew...@ebureau.com writes: I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario: ... So, my counts from the old and new tables match, but the result returned from the insert statement is sometimes a completely different number.

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 guxiaobo1...@qq.com wrote: There is another situation, We have a demo table with about 1700 rows, the select

Re: Reply: [GENERAL] Can we specify transaction level

2013-07-19 Thread bricklen
On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982 guxiaobo1...@qq.com wrote: 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 guxiaobo1...@qq.com wrote: There is another

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 bricklenbrick...@gmail.com 写道: On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982