Re: [BUGS] BUG #1659: primary key accepts null value

#1

On Wed, May 11, 2005 at 01:36:00PM +0100, İbrahim wrote:

Quote:

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/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

#2

İbrahim wrote:

Quote:

The following bug has been logged online:

Bug reference: 1659
Logged by: Ä°brahim
Email address: ibrahimbayer (AT) gmail (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1659: primary key accepts null value

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1659: primary key accepts null value - 05-12-2005 , 08:54 AM

Re: [BUGS] BUG #1659: primary key accepts null value - 05-13-2005 , 08:35 AM