Rod Taylor <rbt(at)rbt(dot)ca> writes:
> As you can see below, after a rename the check constraint still refers
> to 'col' and not 'newname' as pg_constraint.consrc is not updated.
The same issue has always existed with regard to pg_attrdef.adsrc.
pg_dump ought to be using the binary column not the source column, just
as it does for default expressions.
> It seems this is a problem in 7.3 as well. I believe the solution is to
> outright remove consrc, and enable the interface to request a text
> version of conbin on the fly.
I do not think we need to remove the column.
regards, tom lane