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

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Дата
Msg-id 65937bea0803051030q6b8800c0pb6db4e7cae0bb45e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Список pgsql-docs
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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: FAQ on Embedding Postgres
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: FAQ on Embedding Postgres