I see the issues that this person might be having. I am not doing a restore or working on an existing issue.My setup is very vanilla, anyone can create these tables and test, will get the same permission error... (I did it in a brand new environment)What I am asking here is why does a SUPERUSER not able to insert the data when the constraint is introduced.
To prevent a super-user from shooting themselves in the foot. Begin allowed to insert otherwise invalid data is not something that the database allows a superuser to do. A superuser inserting a NULL into a NOT NULL column will also get an error. This is no different.
David J.