Re: Violation of NOT NULL - Mailing list pgsql-general

From Tom Lane
Subject Re: Violation of NOT NULL
Date
Msg-id 5135.1022162399@sss.pgh.pa.us
Whole thread Raw
In response to Violation of NOT NULL  ("Wm. G. Urquhart" <wgu@wurquhart.co.uk>)
List pgsql-general
"Wm. G. Urquhart" <wgu@wurquhart.co.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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Peter Darley"
Date:
Subject: Process balancing on smp db server/apache web server
Next
From: Andrew Sullivan
Date:
Subject: Re: multiple version running