> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> Question 2: what happened to the column "consrc"? > > It was in 11 but not later, so let's look at release notes...
HERE: https://www.postgresql.org/docs/12/release-12.html > « > Remove obsolete pg_constraint.consrc column (Peter Eisentraut) > > This column has been deprecated for a long time, because it did not update in > response to other catalog changes (such as column renamings). The recommended > way to get a text version of a check constraint's expression from > pg_constraint is pg_get_expr(conbin, conrelid). pg_get_constraintdef() is > also a useful alternative. > » Thanks, Adrian. I should have tried Google for "remove pg_constraint consrc". This finds the quote as the top hit. I confirmed that "pg_get_expr(conbin, conrelid)" shows « (v = lower(v)) » for my example table.
