Обсуждение: BUG #1659: primary key accepts null value
The following bug has been logged online: Bug reference: 1659 Logged by: Ä°brahim Email address: ibrahimbayer@gmail.com PostgreSQL version: 8.0.2 Operating system: Windows XP sp1 Description: primary key accepts null value Details: i m using pg 8.0.2 in a project with Visual Studio.NET at Windows Platform but when i send a null value to my Prmary Key column it accepts that value. I think it is a hard problem and i cant delete the null valued primary key column by PgAdmin3 can you help me about this? Thanks Ä°brahim BAYER Computer Engineer
On Wed, May 11, 2005 at 01:36:00PM +0100, Ä°brahim wrote: > > i m using pg 8.0.2 in a project with Visual Studio.NET at Windows Platform > but when i send a null value to my Prmary Key column it accepts that value. PRIMARY KEY implies NOT NULL. Are you sure the value being inserted is NULL and not, for example, an empty string? What's the output of the following query (use your own table and column names)? SELECT pkcolumn, length(pkcolumn), pkcolumn IS NULL FROM tablename; Are you sure the column has a PRIMARY KEY constraint? If you connect with psql, what's the output of the following command? \d tablename -- Michael Fuhr http://www.fuhr.org/~mfuhr/
İbrahim wrote: > The following bug has been logged online: > > Bug reference: 1659 > Logged by: ðbrahim > Email address: ibrahimbayer@gmail.com > PostgreSQL version: 8.0.2 > Operating system: Windows XP sp1 > Description: primary key accepts null value > Details: > > i m using pg 8.0.2 in a project with Visual Studio.NET at Windows Platform > but when i send a null value to my Prmary Key column it accepts that value. > I think it is a hard problem and i cant delete the null valued primary key > column by PgAdmin3 can you help me about this? Thanks ðbrahim BAYER > Computer Engineer Please include a reproducible example, otherwise you cannot expect anyone to help you. Regards, Ezequiel Tolnay