Re: [BUGS] BUG #1436: not null condition is not respected

2005-01-24 Thread Michael Fuhr
On Sun, Jan 23, 2005 at 05:39:05PM +, Florin Borsa wrote: > 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. Zero isn't null, so a NOT NULL constraint wouldn't proh

[BUGS] BUG #1436: not null condition is not respected

2005-01-23 Thread Florin Borsa
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 fi