Postgres Pro
Downloads
Home   >   mailing lists

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

From Joshua D. Drake
Subject Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields
Date
Msg-id 1290059607.10258.7972.camel@jd-desktop
Whole thread Raw
In response to ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields  (Allan Kamau <kamauallan@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields
Next
From: Allan Kamau
Date:
Subject: Re: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields