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
Allan Kamau kamaual...@gmail.com writes:
CREATE TABLE farm.produce
(id INTEGER NOT NULL DEFAULT NEXTVAL('farm.produce_seq')
,process___id TEXT NOT NULL
,item_names tsvector NULL
,product__ids__tsquery tsquery NULL
,product__ids__tsvector tsvector NULL
,population_time TIMESTAMP NOT NULL
On Thu, Nov 18, 2010 at 6:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Allan Kamau kamaual...@gmail.com writes:
CREATE TABLE farm.produce
(id INTEGER NOT NULL DEFAULT NEXTVAL('farm.produce_seq')
,process___id TEXT NOT NULL
,item_names tsvector NULL
,product__ids__tsquery tsquery NULL
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?
Allan.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Allan Kamau kamaual...@gmail.com writes:
I am experiencing the row is too big error (with postgreSQL-9.0.1)
when populating a table having a tsquery and tsvector fields.
Could we see the exact declaration of your table, please? Did you
play games with the STORAGE attribute of any of your
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
On Thu, Nov 18, 2010 at 8:35 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Allan Kamau kamaual...@gmail.com writes:
I am experiencing the row is too big error (with postgreSQL-9.0.1)
when populating a table having a tsquery and tsvector fields.
Could we see the exact declaration of your table,