Re: [HACKERS] row is too big: size 8916, maximum size 8136

2005-12-07 Thread Jan Wieck
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

Re: [HACKERS] row is too big: size 8916, maximum size 8136

2005-12-06 Thread Mark Kirkwood
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 Sl

Re: [HACKERS] row is too big: size 8916, maximum size 8136

2005-12-06 Thread Michael Fuhr
On Tue, Dec 06, 2005 at 11:03:16PM -0300, Euler Taveira de Oliveira wrote: > 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 us

Re: [HACKERS] row is too big: size 8916, maximum size 8136

2005-12-06 Thread Tom Lane
Euler Taveira de Oliveira <[EMAIL PROTECTED]> writes: > I'm doing some tests with a 700 columns' table. Redesign your schema... regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[HACKERS] row is too big: size 8916, maximum size 8136

2005-12-06 Thread Euler Taveira de Oliveira
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 yo