Create Table Unique problem... bug?

From: Mauro Bertoli <bertolima(at)yahoo(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Create Table Unique problem... bug?
Date: 2003-05-28 13:34:41
Message-ID: 20030528133441.99434.qmail@web13406.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, I've a problem creating a table. My Sql
instruction is:

CREATE TABLE questiontypes (
id integer NOT NULL,
flags integer,
label text,
UNIQUE (id,flags)
);

Is it ok?? I must have 'flags' like to NULL... but
'id' is NOT NULL...
Now if I insert a row:

INSERT INTO questiontypes (id,flags,label) values
(2,null,'a');

and re-insert it... I can!!!! Now there are two
identical row, and UNIQUE??
I think postgres must occur an error? Is it Ok?

(The same problem is with:
INSERT INTO questiontypes (id,label) values (2,'a');
Is it ok?)

Thanks you, Mauro

______________________________________________________________________
Yahoo! Mail: 6MB di spazio gratuito, 30MB per i tuoi allegati, l'antivirus, il filtro Anti-spam
http://it.yahoo.com/mail_it/foot/?http://it.mail.yahoo.com/

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-05-28 13:50:26 Re: Create Table Unique problem... bug?
Previous Message Mauro Bertoli 2003-05-28 13:26:19 Create Table Unique problem... bug?