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:
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
Bruce Momjian <bruce@momjian.us> writes:That's a problem, and the length limit is different for different index
> Part of the problem is we don't know the length --- it is the compressed
> length that is limited, I think to 8k.
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 по дате отправления: