Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: Allan Kamau <kamauallan(at)gmail(dot)com>
Subject: Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields
Date: 2010-11-18 13:45:05
Message-ID: 201011181445.06649.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 18 November 2010 05:37:51 Allan Kamau wrote:
> Hi,
> I am experiencing the "row is too big" error (with postgreSQL-9.0.1)
> when populating a table having a tsquery and tsvector fields.
> Are fields of tsquery and tsvector datatypes affected by this row size
> restriction?
Looks like you tried to index the text field itself with a btree?

Andres

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-11-18 14:47:40 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Previous Message Pavel Stehule 2010-11-18 12:57:02 Re: plpgsql, Exception handling: catching the message ?