Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key joins revisited - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Foreign key joins revisited
Date
Msg-id CADkLM=fROz07vZsKpi=WsU=0_qP2AsV6bMEz9k_9ofz6=-cyyQ@mail.gmail.com
Whole thread Raw
In response to Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
Tree view

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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Column Filtering in Logical Replication
Next
From: Tom Lane
Date:
Subject: Re: default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)