- Vertabelo
-
Bugs
0
Pas un bug
Don'tt update the column type PK-FK relationships
When I change the column type to another value in a table with PK in another table that contains the FK does not update.
It will correct this?
Sorry for my english, thanks.
It will correct this?
Sorry for my english, thanks.
Solution
Solution
Pas un bug
Not updating the type of FK column is a desired behaviour. This is because you can have, for instance, "SERIAL" datatype for your PK and "INT" type for FK and this is perfectly valid structure (I'm talking about PostgreSQL now, but such cases exist in other RDBMSs as well).
If you change the PK type and the types of PK and FK don't match, you should get an error in the "Problems" section.
If you change the PK type and the types of PK and FK don't match, you should get an error in the "Problems" section.
Hello
If you're right, but in my opinion when you change the data type in my PK, FK should not automatically change it manually.
Another observation I could see is that by eliminating the relationship between two tables "a" and "b", the referenced FK not removed, you also would have to do it manually?
This drawback I see for SQL Server, if not for others will be the same.
Sorry for my English.
Thank you.
If you're right, but in my opinion when you change the data type in my PK, FK should not automatically change it manually.
Another observation I could see is that by eliminating the relationship between two tables "a" and "b", the referenced FK not removed, you also would have to do it manually?
This drawback I see for SQL Server, if not for others will be the same.
Sorry for my English.
Thank you.
+1
If it's about automatic FK column removal after reference deletion - I agree. We have this on our TODO list and it will be done in the nearest future, maybe even in the next week!
Service d'assistance aux clients par UserEcho
If you change the PK type and the types of PK and FK don't match, you should get an error in the "Problems" section.