1. Vertabelo
  2. Fejl
0
Ikke en bug

Don'tt update the column type PK-FK relationships

Michael Medina 10 år siden • opdateret af anonymous 10 år siden • 3
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.

Svar

Svar
Ikke en bug
anonymous 10 år siden
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.
Svar
Ikke en bug
anonymous 10 år siden
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.
Michael Medina 10 år siden
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.
+1
anonymous 10 år siden
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!

Kundesupport af UserEcho