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.
