TLDR; I would like to get a warning on changing/adding a foreign key for Postgresql that it locks the table and if the table is large, it could be locked for some time. When adding or changing a ...
PostgreSQL has an extension to sql that creates exclusive indices like ( no overlapping ranges, no overlapping GIS shapes, etc ) using the gist indices. The syntax isn't all that complex. I would like ...