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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Allan Kamau <kamauallan(at)gmail(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields
Date: 2010-11-18 05:53:27
Message-ID: 1290059607.10258.7972.camel@jd-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2010-11-18 at 07:37 +0300, 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?

Uhh... what index type did you use on the column?

>
>
> Allan.
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2010-11-18 06:50:49 Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields
Previous Message Tom Lane 2010-11-18 05:35:18 Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields