Re: [GENERAL] limit over attribute size if index over it exists

2006-06-26 Thread Tom Lane
"pajai" <[EMAIL PROTECTED]> writes: > I have got an issue with PostgreSQL. There is a limitation on the > column length of a tuple, in case there is an index over it. In the > actual project I am working on, I meet such a situation. I have got an > attribute over which I am doing a search (that is,

Re: [GENERAL] limit over attribute size if index over it exists

2006-06-26 Thread Martijn van Oosterhout
On Mon, Jun 26, 2006 at 02:52:56AM -0700, pajai wrote: > I have thought of a possible workaround. I would like to know if it > seems reasonable. The idea would be to build a hash, on the client > side, over the problematic column (let's say column a). I then store in > the db the attribute a (witho

[GENERAL] limit over attribute size if index over it exists

2006-06-26 Thread pajai
Hi everybody, I have got an issue with PostgreSQL. There is a limitation on the column length of a tuple, in case there is an index over it. In the actual project I am working on, I meet such a situation. I have got an attribute over which I am doing a search (that is, I need an index over it), bu