unique constraint - bug?
От | Merrill Oveson |
---|---|
Тема | unique constraint - bug? |
Дата | |
Msg-id | 39762A1F.B5089BED@actiontarget.com обсуждение исходный текст |
Ответы |
Re: unique constraint - bug?
|
Список | pgsql-general |
All: Run the following script: drop table letter; create table letter ( a char(1), b char(1), c char(1), unique (a, b, c) ); insert into letter values('1','2','3'); insert into letter values('1','2','3'); insert into letter (a,c) values ('1','3'); insert into letter (a,c) values ('1','3'); Notice that the second insert of ('1','2','3') yields an error message, which is the correct behavior - (that is the unique constaint is working), while the last insert of ('1','3') does not yield an error message - (that is the unique constraint doesn't work in this case - I think it should). It appears as though the null value inserted for column b causes an abrogation of the unique constaint. Is this intended or is it a bug? Or should I be doing something different? Thanks Merrill
В списке pgsql-general по дате отправления: