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

[Koichi S. <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
>