133_add_not_null_constraint_to_container_handle.go

package migrations

import "github.com/concourse/atc/dbng/migration"

func AddNotNullConstraintToContainerHandle(tx migration.LimitedTx) error {
	_, err := tx.Exec(`
		ALTER TABLE containers
		DROP CONSTRAINT handle_when_created,
		ALTER COLUMN handle SET NOT NULL
	`)
	if err != nil {
		return err
	}

	return nil
}