We are using PG 11 so we should be able to add a new column with a default value to a big table with no problems, however to also add a NOT NULL constraint would be another matter
is there a way in sequel to write the following alter table statement ? ALTER TABLE *table_name *ADD CONSTRAINT *constraint_name* CHECK (*column* IS NOT NULL) NOT VALID; and then ALTER TABLE *table_name* VALIDATE CONSTRAINT* constraint_name*; that way we don't validate the constraint on creation hence not acquiring an exclusive lock on the table ? -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/adf93e83-fac0-409d-a1b0-9e6a504ebc21n%40googlegroups.com.
