The following bug has been logged online:

Bug reference:      1436
Logged by:          Florin Borsa
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system:   Windows XP
Description:        not null condition is not  respected
Details: 

I ceate a table with some integer fields in this way:

create table homes ( nr int not null, name char(4))

I can insert in this table zero and null values for nr field.

where is the error, because I do not want to permit insertion of zero or
null values for nr field in homes table ?

Thank you !

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to