On Tue, Apr 17, 2012 at 07:46:26PM +0200, Roberto Caravani wrote:
> 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 learned from the documentation. The problem is that I get an error when inserting data, that the index is to large. I would like 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,
You may need to store a crypographic signature for the data and unique that instead.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2012-04-17 19:18:53|
|Subject: Re: unique constraint |
|Previous:||From: Roberto Caravani||Date: 2012-04-17 17:46:26|
|Subject: unique constraint|