+1
À l'étude
SQL import for postgres fails to infer NOT NULL for PRIMARY KEY
For the following CREATE statement
CREATE TABLE tst ( id int, primary key (id) );
postgres infers, that since id is primary key, it should be not null and ends up creating following table:
| Column | Type | Modifiers
|--------+---------+----------- | id | integer | not null
In vertabelo, while importing model form SQL, the not null modifier is not added and I get "Primary key column can't be null" error.
0
À l'étude
anonymous il y a 9 ans
Service d'assistance aux clients par UserEcho