Re: Two questions about "pg_constraint"

Поиск
Список
Период
Сортировка
От Bryn Llewellyn
Тема Re: Two questions about "pg_constraint"
Дата
Msg-id CAAB2CE0-F545-4C87-9466-B499A97378DC@yugabyte.com
обсуждение исходный текст
Ответ на Re: Two questions about "pg_constraint"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
That's the answer I was seeking. So it's case closed for both of my « Two questions about "pg_constraint" ». Thanks, Tom. And thanks to the others who've contributed to this thread.



My other question was about the "connamespace" column. It seemed to me, both at first and still now, that this is a clear instance of a transitive dependency.

I think a more productive way to think about it is that it's denormalization for efficiency; specifically to let constraints be looked up by name+namespace without having to get other catalogs involved.  (SET CONSTRAINTS is one thing that requires that, and I think there are others.)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Two questions about "pg_constraint"
Следующее
От: Вадим Самохин
Дата:
Сообщение: questions about snapshot building logic