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:26:19 |
Message-ID: | 20030528132619.49833.qmail@web13402.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/
From | Date | Subject | |
---|---|---|---|
Next Message | Mauro Bertoli | 2003-05-28 13:34:41 | Create Table Unique problem... bug? |
Previous Message | Nabil Sayegh | 2003-05-28 13:25:28 | Re: Inserting data of two other tables [Now deleting ...] |