Hello, I suppose it is a trade-off to make the parser light and fast. But invalid column constraints are ignored.
sqlite> create table tbl (data text constraint x); postgres=# create table tbl (data text constraint x); ERROR: syntax error at or near ")" at character 41 sqlite> create table tbl (data text deferrable initially deferred); postgres=# create table tbl (data text deferrable initially deferred); ERROR: misplaced DEFERRABLE clause at character 29 sqlite> create table tbl (data text not null constraint x); postgres=# create table tbl (data text not null constraint x); ERROR: syntax error at or near ")" at character 50 Regards. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users