parsing error near unique not null

[dfong]

with ramsql i get the above error on this statement,

create table tables(name text unique not null)

which works fine if i use the sqlite3 driver instead.

[proullon]

yes unique is not implemented (it's #15 )
I'll see what I can do this week

[proullon]

done

[dfong]

thanks for rapidly fixing these bugs.

[fabulias]

But UNIQUE only works as a column constraint, I try with table constraint and the output is an error.

I want:
CREATE TABLE IF NOT EXISTS sample_table (id SERIAL PRIMARY KEY, name TEXT, UNIQUE(name));
I got:
ERROR : cannot execute : Syntax error near , unique (

If I try with this:
CREATE TABLE IF NOT EXISTS sample_table (id SERIAL PRIMARY KEY, name TEXT UNIQUE);
I got:
Query OK. 1 rows affected