| From: | list_man <listman(at)elkenserver(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | TOAST not working |
| Date: | 2006-06-10 13:03:42 |
| Message-ID: | 1149944622.15368.38.camel@vaio1linux |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs 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 v8.0x
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-10 16:28:18 | Re: TOAST not working |
| Previous Message | Bruce Momjian | 2006-06-07 12:58:02 | Re: vacuum and routine maintenance docs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pobox@verysmall.org | 2006-06-10 13:11:52 | Re: php 5.1.4 with PostgreSQL 8.1.4 causes Apache 1.3.36 |
| Previous Message | Jorge Godoy | 2006-06-10 12:09:16 | Re: not valid character for Unicode |