Re: Foreign key joins revisited

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Foreign key joins revisited
Дата
Msg-id CADkLM=fROz07vZsKpi=WsU=0_qP2AsV6bMEz9k_9ofz6=-cyyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
Список pgsql-hackers
Дерево обсуждения

First, there is only one FK in permission pointing to role, and we write a query leaving out the key columns.
Then, another different FK in permission pointing to role is later added, and our old query is suddenly in trouble.


We already have that problem with cases where two tables have a common x column:

SELECT x FROM a, b

so this would be on-brand for the standards body. And worst case scenario you're just back to the situation you have now.
 

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Column Filtering in Logical Replication
Следующее
От: Tom Lane
Дата:
Сообщение: Re: default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)