Re: [sqlite] invalid column constraint ignored

On 6/12/17, gwenn wrote: > invalid column constraints are ignored. This is a consequence of designing SQLite according to Postel's Law (https://en.wikipedia.org/wiki/Robustness_principle) which was very popular 17 years ago when SQLite was being designed, but nowadays has

[sqlite] invalid column constraint ignored

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