On 22.04.22 16:14, Tom Lane wrote:
That analogy would be compelling if exclusion constraints were a SQL-standard feature; but they aren't so their clause syntax is fully under our control. The scenario that worries me is that somewhere down the pike, the SQL committee might extend the syntax of PKEY/UNIQUE constraint clauses in a way that breaks our nonstandard extensions of them.
Some syntax like
PRIMARY KEY (x, y) USING ACCESS METHOD hash
should be able to avoid any future clashes.
