For example:
Table A
-id (PK)
-name
Table B
-table_a_id (PK, FK)
-address
When I do an insert on table B, the database check if value for column “table_a_id” exists in table A
But, if I do an update of column “address” of table B, does the database check again?
My question is due to the nature of and update in postgres, that basically is a new version “insert”.
Thanks