Re: Foreign key joins revisited

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joel Jacobson" <joel(at)compiler(dot)org>
Cc: "Isaac Morland" <isaac(dot)morland(at)gmail(dot)com>, "Corey Huinker" <corey(dot)huinker(at)gmail(dot)com>, "PostgreSQL Developers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Foreign key joins revisited
Date: 2021-12-28 19:41:04
Message-ID: 1915741.1640720464@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Joel Jacobson" <joel(at)compiler(dot)org> writes:
> Since my last email in this thread, I've learned KEY is unfortunately not a reserved keyword.
> This probably means the proposed "JOIN KEY" would be problematic, since a relation could be named KEY.

> Can with think of some other suitable reserved keyword?

FOREIGN? Or even spell out "JOIN FOREIGN KEY".

> How about JOIN WITH?

Seems largely unrelated.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2021-12-28 19:45:12 Re: Foreign key joins revisited
Previous Message Joel Jacobson 2021-12-28 19:26:36 Re: Foreign key joins revisited