On 3rd of November, Heikki Linnakangas committed patch: Support range data types. Selectivity estimation functions are missing for some range type operators, which is a TODO. Jeff Davis
On 30th of June, Alvaro Herrera committed patch: Enable CHECK constraints to be declared NOT VALID This means that they can initially be added to a large existing table without checking its initial contents, but new tuples must comply to them; a separate pass ...
On 8th of February, Simon Riggs committed patch: Extend ALTER TABLE to allow Foreign Keys to be added without initial validation. FK constraints that are marked NOT VALID may later be VALIDATED, which uses an ShareUpdateExclusiveLock on constraint table and RowShareLock on referenced table. ...
On 25th of January, Tom Lane committed patch: Implement ALTER TABLE ADD UNIQUE/PRIMARY KEY USING INDEX. This feature allows a unique or pkey constraint to be created using an already-existing unique index. While the constraint isn't very functionally different from the bare index, ...
Fight! But more seriously - people tend to use various data types, and there have been some myths about them, so let's see how it really boils down. First of all - All those data types are internally saved using the same ...
On 7th of December, Tom Lane committed patch by Jeff Davis that adds general exclusion constraints: Log Message: ----------- Add exclusion constraints, which generalize the concept of uniqueness to support any indexable commutative operator, not just equality. Two rows violate the exclusion constraint if ...
On 20th of November Tom Lane committed patch by Takahiro Itagaki which adds interesting functionality: Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be checked to determine whether the trigger should be fired. For BEFORE triggers this is mostly ...
On 1st of August Tom Lane committed patch from Itagaki Takahiro: Improve unique-constraint-violation error messages to include the exact values being complained of. In passing, also remove the arbitrary length limitation in the similar error detail message for foreign key violations. Itagaki Takahiro and later added ...
On 29th of July ( I know, there is a long backlog in waiting for 8.5 series. I'm working on it :), Tom Lane committed patch by Dean Rasheed: Support deferrable uniqueness constraints. The current implementation fires an AFTER ROW trigger for ...
On 205h of July Andrew Dunstan committed patch by Andres Freund : Log Message: ----------- DROP IF EXISTS for columns and constraints. Andres Freund.
