unique constraint
От | Roberto Caravani |
---|---|
Тема | unique constraint |
Дата | |
Msg-id | 20120417174626.10610@gmx.net обсуждение исходный текст |
Ответы |
Re: unique constraint
Re: unique constraint |
Список | pgsql-novice |
Hi! I have a little problem with a unique constraint: create table meta_data ( id serial primary key, type int not null, data bytea not null, unique (type, data) ); data can be quite large (a few hundred kilo bytes). The unique constraint automatically creates a btree index as I learnedfrom the documentation. The problem is that I get an error when inserting data, that the index is to large. I wouldlike to keep the unique constraint, is there a way to fix this? I googled the problem and found others having similar issues, but I have not found a solution that suited me. Thanks in advance! Best regards, Robert -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a
В списке pgsql-novice по дате отправления: