Postgres SchemaManager is reading a default of -1 as (-1) for postgres 9.4

[DeepDiver1975]

Postgres 9.5

Postgres 9.4

Connected to a 9.4 server the default value is stored in the schema diff as (-1) but when comparing to a desired target schema where a -1 is expected a change is unnecessarily detected.

Is this something to be handled in the postgressql schema manager class?

THX

[DeepDiver1975]

Original create statement

CREATE TABLE "oc_hmffile_locks" ("id" SERIAL NOT NULL, "lock" INT DEFAULT 0 NOT NULL, "key" VARCHAR(64) NOT NULL, "ttl" INT DEFAULT -1 NOT NULL, PRIMARY KEY("id"))

[deeky666]

Hmmm is it an incompatibility between 9.4 and 9.5? Why is the default value stored as a literal in 9.5 but in 9.4 it is stored as an expression? How did you declare the default value in the DDL for the 9.5 table?

[deeky666]

Patch provided in #2614

[Ocramius]

Can't fix in 2.5.x due to lack of Postgres94Platform. Gonna be a 2.6 only fix.

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.