On Tue, Mar 10, 2015 at 8:20 AM, Andrzej Pilacik <cypise...@gmail.com> wrote:
> 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.
