Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Phil Frost <phil(at)macprofessionals(dot)com>, PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Date: 2008-03-05 17:09:44
Message-ID: 359.1204736984@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Part of the problem is we don't know the length --- it is the compressed
> length that is limited, I think to 8k.

That's a problem, and the length limit is different for different index
types. So you're really not going to be able to say anything very
specific. Another problem is where would you put the information?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gurjeet Singh 2008-03-05 18:30:33 Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Previous Message Bruce Momjian 2008-03-05 16:56:44 Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2008-03-05 17:35:53 Re: FAQ on Embedding Postgres
Previous Message Bruce Momjian 2008-03-05 16:56:44 Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values