There must not be constraints at all. Constraints are needed to check incoming data to the table. But here table is
read-onlyfor database!
So all your constraints is totally useless.
> > could become:
> >
> > connection_from text check(connection_from ~ '^[^:]+:[0-9]+$) -- the host and
> > port of the client, colon-separated
> David J.