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:
what does
On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982 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 wrote:
>
> There is another situation,
>
>
> We have a de
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) from
demotabl
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) from
> demotable" statement finishes with-in 3 seconds when executed directlly
> against the Greenplum database,but it takes about 230 secon
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_
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
"=?gb18030?B?Z3V4aWFvYm8xOTgy?=" writes:
> It works for insert and select statement under serializable level, but it
> seems update/delete statements are not support, is that true?
> template1=# update user_info set info='1234' where id=102;
> ERROR: DECLARE CURSOR ... FOR UPDATE/SHARE is not su
It works for insert and select statement under serializable level, but it seems
update/delete statements are not support, is that true?
template1=# update user_info set info='1234' where id=102;
ERROR: DECLARE CURSOR ... FOR UPDATE/SHARE is not supported
DETAIL: Cursors must be READ ONLY.
CONT
