public inbox for [email protected]
help / color / mirror / Atom feedFrom: Gurjeet Singh <[email protected]>
To: Tom Lane <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Phil Frost <[email protected]>
Cc: PostgreSQL-documentation <[email protected]>
Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
Date: Thu, 6 Mar 2008 00:00:33 +0530
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
On Wed, Mar 5, 2008 at 10:39 PM, Tom Lane <[email protected]> wrote:
> Bruce Momjian <[email protected]> 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?
In 'CREATE INDEX' docs...
http://www.postgresql.org/docs/8.3/interactive/sql-createindex.html
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
view thread (20+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox