TOAST not working - Mailing list pgsql-general

From list_man
Subject TOAST not working
Date
Msg-id 1149914458.15368.31.camel@vaio1linux
Whole thread Raw
List pgsql-general
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 v 8k


pgsql-general by date:

Previous
From: dananrg@yahoo.com
Date:
Subject: Re: Best open source tool for database design / ERDs?
Next
From: "Adam"
Date:
Subject: Logging and Viewing SQL History