X-Original-To: pgsql-general-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 4CC279FA5BA
	for <pgsql-general-postgresql.org@postgresql.org>;
	Sat, 10 Jun 2006 12:05:49 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 86127-10 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Sat, 10 Jun 2006 12:05:40 -0300 (ADT)
X-Greylist: delayed 01:17:33.570405 by SQLgrey-
Received: from mail.elkenserver.net (unknown [63.236.47.51])
	by postgresql.org (Postfix) with ESMTP id 221699F9AD3
	for <pgsql-general@postgresql.org>;
	Sat, 10 Jun 2006 12:05:39 -0300 (ADT)
Received: (qmail 30106 invoked by uid 507); 10 Jun 2006 08:52:22 -0400
Received: from localhost (HELO svn.elkenserver.net) (127.0.0.1)
	by mail.elkenserver.net with SMTP; 10 Jun 2006 08:52:22 -0400
Subject: TOAST not working
From: list_man <listman@elkenserver.net>
Reply-To: listman@elkenserver.net
To: pgsql-general@postgresql.org
Content-Type: text/plain
Date: Sat, 10 Jun 2006 09:03:42 -0400
Message-Id: <1149944622.15368.38.camel@vaio1linux>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.4 (2.0.4-7) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/394
X-Sequence-Number: 96766


Hi,

I wonder if anyone can help.

I have a VERY wide table and rows. There are over 800 columns of type:
numeric(11,2)

I can create the table no problem, but when I go to fill out a full row
with data, I get the message about reaching the 8k limit.

Can someone tell me if I have to 'enable' TOAST on columns to have  it
kick in. According to my research, numeric data types are toastable.

I'd appreciate if anyone can give me lit1e.

Thanks

PS. I'm running Postgres v8.0x