Sanjay Arora <sk(at)pobx(dot)com> writes:
> Assuming even that the application is trying to store null where it should
> not, PG should raise an error, instead of accepting the same.
Indeed. No one has reported any such problem before, AFAIR. Are you
sure the columns are marked NOT NULL?
regards, tom lane