Re: Violation of NOT NULL

Tom Lane wrote:
>
> "Wm. G. Urquhart" <wgu(at)wurquhart(dot)co(dot)uk> writes:
> > I have a table where I've set two of the columns (varchar()) to be NOT
> > NULL. However, PostgreSQL allows me to enter rows without valid data for
> > these columns when I use a Stored Function.
>
> I don't really believe this, and I'm certainly not likely to be able to
> reproduce it with nothing but an INSERT to go on. Please provide a
> *complete* example, preferably in the form of a script that can be fed
> to psql to exhibit the problem starting from an empty database.

Also, if by chance you are coming over from Oracle and expect an empty
string to be treated as NULL, it is not...

Mike Mascari
mascarm(at)mascari(dot)com