xnuinside/simple-ddl-parser

ALTER Constraint UNIQUE must be showed in column also

xnuinside opened this issue · 2 comments

Issue was reported here: #99

This is a big help. It parses without throwing an exception now! I think there's still room for improvement in understanding the meaning of the Postgres schema. For example, the DDL contains

ALTER TABLE ONLY public.accounts ADD CONSTRAINT accounts_username_key UNIQUE (username);

But in the parsed output, we see:

{'name': 'username',
'type': 'character varying',
'size': 50,
'references': None,
'unique': False, <======= should be True?
'nullable': False,
'default': None,
'check': None},
But the bug I reported is fixed, so closing this issue.

problem was in ALTER TABLE ONLY (only was not supported)

fixed in 0.23.0 release