On 12/6/2005 9:03 PM, Euler Taveira de Oliveira wrote:
> Hi,
>
> I'm doing some tests with a 700 columns' table. But when I try to load
> some data with INSERT or COPY I got that message. I verified that the
> BLCKZ is limiting the tuple size but I couldn't have a clue why it's
> not using TOAST. I'm using PostgreSQL 8.0.3 in Slackware 10.1 box.
> Let me know if you want a test case or other useful information.
The external reference of a toasted attribute is 20 bytes in size.
I might be wrong, but at 700 columns you have to ask your developers
some serious questions about their qualification.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #