On Sat, Nov 03, 2012 at 09:30:46PM -0200, Marcelo Lacerda wrote:

Hey there, when I run this

create table dim_date (id integer autoincrement primary key, date date unique not null);

I get this

syntax error, unexpected IDENT, expecting ')' or ',' in: "create table dim_date (id integer autoincrement"

Is that expected? Try auto_increment. That should fix your sql.

Niels

I'm running a compiled version of monet 11.13.3 on a debian machine.

-- Marcelo Lacerda

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list