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

[Koichi S. <ko...@in...>]

This should be put into the track.

I discussed with Michael and found that the issue is not that simple
because we should consider the case of the replicated table.   It is not
correct to get sequence value directly from GTM to Datanode in this
case.   Coordinator should handle this.

Regards;
---
Koichi

(2010年12月09日 10:11), xiong wang wrote:
> 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
>>>
>>
>>
>