Simon Riggs wrote:
> On 8 January 2016 at 14:14, Vitaly Burovoy <vitaly.burovoy@gmail.com> wrote:
>
> > What about SET NOT NULL constraints? There is no VALIDATE CONSTRAINT for
> > it.
>
> Sounds like a useful addition.
Yes. In order to make it a reality you need to make the NOT NULL
constraints appear in pg_constraint. Years ago I wrote a patch to do
that, which was very close to done. It would be really cool if Vitaly
or someone else could look into that patch, update it and get it ready
for commit.
If someone is interested, I can send the patch along.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services