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 |