Re: [Postgres-xc-developers] bug：sequence problem

[xiong w. <wan...@gm...>]

Hi Koichi,

Yes, I consider sequence should be created on datanodes but not only
on coordinators. But all the sequence value should be from GTM.

Regards,
Benny

2010/12/9 Koichi Suzuki <ko...@in...>:
> In the current implementation, sequence value is supplied by GTM, as you
> know.   It is assumed that this value is supplied to the datanode through
> the coordinator.   In the case of your case, default value must be handled
> by the datanode and the datanode has to inquire GTM for the nextval of the
> sequence.
>
> I'm afraid this is missing in the current code.
> ---
> Koichi
>
> (2010年12月08日 19:33), xiong wang wrote:
>>
>> Dears,
>>
>> steps:
>> postgres=# create sequence seq start with 1;
>> CREATE SEQUENCE
>> postgres=# create table t(a int default nextval('seq'), b int);
>> ERROR:  Could not commit (or autocommit) data node connection
>>
>> datanode log as follows:
>> LOG:  statement: create table t(a int default nextval('seq'), b int);
>> ERROR:  relation "seq" does not exist
>>
>> When I checked the source code, I found sequence can't be created on
>> datanodes. Could you explain why?
>>
>> Regards,
>> Benny
>>
>>
>> ------------------------------------------------------------------------------
>> What happens now with your Lotus Notes apps - do you make another costly
>> upgrade, or settle for being marooned without product support? Time to
>> move
>> off Lotus Notes and onto the cloud with Force.com, apps are easier to
>> build,
>> use, and manage than apps on traditional platforms. Sign up for the Lotus
>> Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>
>