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