There must not be constraints at all. Constraints are needed to check incoming data to the table. But here table is read-only for 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.