Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values - Mailing list pgsql-docs

From Tom Lane
Subject Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Date
Msg-id 359.1204736984@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
List pgsql-docs
Bruce Momjian <bruce@momjian.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

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Next
From: Tom Lane
Date:
Subject: Re: FAQ on Embedding Postgres