postgres: Comments on check doesn't work. If the check expression has AND, even if they are exactly the same, atlas still will delete and recreate the constraints

[Huliiiiii]

Atlas version: 0.29.0
Postgres version: 17

Example hcl:

schema "public" {
  comment = "standard public schema"
}

table "test_table" {
	schema = schema.public

	column "id" {
		type = int
	}
	primary_key {
		columns = [column.id]
	}

	column "value" {
		type = int
	}

	check "value_check" {
		comment = "This is a comment"
		expr = "value > 0 AND value < 1000"
	}
}

What I saw after running atlas schema apply：

Planning migration statements (1 in total):

  -- modify "test_table" table:
    -> ALTER TABLE "public"."test_table" DROP CONSTRAINT "value_check", ADD CONSTRAINT "value_check" CHECK (value > 0 AND value < 1000);

[a8m]

Hey! Do you use a dev-database in your commands? See: https://atlasgo.io/concepts/dev-database

[Huliiiiii]

Ok, this fix issue of check expression.
But comment still not work.

[Huliiiiii]

And if i change the name of the check, will still show the message: "Schema is synced, no changes to be made"

[Huliiiiii]

I think some better info is needed here:
For example: ”If the dev database is not set, Atlas cannot validate the check constraints, which causes Atlas to drop and recreate them.“

[a8m]

What command do you use?

[Huliiiiii]

atlas schema apply -u $env:DATABASE_URL --to=file://schema.pg.hcl --dev-url $env:DEV_DATABASE_URL

[Huliiiiii]

Digging a little deeper, Atlas only detects changes if I change the check expression.

[a8m]

Yes, this was intentional some time ago (before the dev-database was added to Atlas). We will change this in the upcoming release.