Btw, if a table is 'supposed to be' one way or another, then it should be so constrained, so that the database won't allow any other state.

See, for instance: constraints

(INSERT ... RETURNING, if your database supports it, might be of interest too.)