Postgres Pro
Downloads
Home   >   mailing lists

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

From Gurjeet Singh
Subject Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Date
Msg-id 65937bea0803051030q6b8800c0pb6db4e7cae0bb45e@mail.gmail.com
Whole thread Raw
In response to Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs
Tree view
On Wed, Mar 5, 2008 at 10:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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?

Along with the following statement:

method: The name of the index method to be used. Choices are btree, hash, gist, and gin. The default method is btree.

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

17° 29' 34.37"N,  78° 30' 59.76"E - Hyderabad *
18° 32' 57.25"N,  73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco

http://gurjeet.frihost.net

Mail sent from my BlackLaptop device

pgsql-docs by date:

Previous
From: David Fetter
Date:
Subject: Re: FAQ on Embedding Postgres
Next
From: "Joshua D. Drake"
Date:
Subject: Re: FAQ on Embedding Postgres