|
From: David H. <dav...@me...> - 2011-07-15 11:02:05
|
After playing around with postgres-xc 0.9.5, I wanted to give my actual
application a try. I get the following error message when setting up the
base schema: "ERROR: Postgres-XC does not support DEFAULT with
non-immutable functions yet". This happens when setting up a column as
follows (this is btw copied verbatim from the postgresql documentation,
explaining how a serial type works):
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
colname integer NOT NULL DEFAULT nextval('tablename_colname_seq')
);
ALTER SEQUENCE tablename_colname_seq OWNED BY tablename.colname;
I've read that (global) sequences and serial are not yet supported. I
checked the roadmap and couldn't find mention of this explicitly. I was
wondering if support is planned, and if so, when? (And if not, why :-).
Thanks,
David
|