does update of column with no relation imply a relation check of other column?

Поиск
Список
Период
Сортировка
От Anibal David Acosta
Тема does update of column with no relation imply a relation check of other column?
Дата
Msg-id 00ce01cc8e76$ed533480$c7f99d80$@devshock.com
обсуждение исходный текст
Ответы Re: does update of column with no relation imply a relation check of other column?
Список pgsql-performance

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: How many Cluster database on a single server
Следующее
От: Greg Jaskiewicz
Дата:
Сообщение: Re: does update of column with no relation imply a relation check of other column?