On Wed, Feb 8, 2023 at 11:01 AM Mark Hills <mark@xxxxxxxx> wrote:
CREATE DOMAIN hash AS text
CHECK (VALUE ~ E'^[a-zA-Z0-9]{8,32}$');
devstats=> ALTER TABLE invite ADD COLUMN test hash;
ALTER TABLE
Time: 30923.380 ms (00:30.923)
Necessarily, I presume because if you decided that the check on the domain should be "value is not null" (don't do this though...) the column addition would have to fail for existing rows (modulo defaults...).
David J.
