adrian.klaver@xxxxxxxxxxx wrote:
bryn@xxxxxxxxxxxx wrote:Question 2: what happened to the column "consrc"?
It was in 11 but not later, so let's look at release notes...
HERE:
« 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. | 