Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 05 Mar 2008 12:09:44 -0500
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
- Follow-Ups:
- Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- From: Gurjeet Singh
- Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- References:
- Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- From: Bruce Momjian
- Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- Prev by Date: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- Next by Date: Re: FAQ on Embedding Postgres
- Previous by thread: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- Next by thread: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
- Indexes: