[ADMIN] postgres block_size problem

2008-12-30 Thread Bhujbal, Santosh
Hi All, We were getting the following error on executing a COPY command on postgres8.2.0. SQL execution failed, Internal error. SQL Statement: (COPY command failed with error: ERROR: row is too big: size 8200, maximum size 8136) So, in order to fix the error we tried increasing the block size t

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Peter Eisentraut
Bhujbal, Santosh wrote: Hi All, We were getting the following error on executing a COPY command on postgres8.2.0. SQL execution failed, Internal error. SQL Statement: (COPY command failed with error: ERROR: row is too big: size 8200, maximum size 8136) So, in order to fix the error we trie

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh wrote: > Hi All, > > We were getting the following error on executing a COPY command on > postgres8.2.0. First and foremost, you need to run the latest version of 8.2, not 8.2.0. .0 releases of postgresql tend to have the most bugs. You're missi

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Tom Lane
"Scott Marlowe" writes: > On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh > wrote: >> SQL execution failed, Internal error. SQL Statement: (COPY command failed >> with error: ERROR: row is too big: size 8200, maximum size 8136) > Hmmm. What exactly are you trying to insert into what? Normal

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 12:56 PM, Tom Lane wrote: > "Scott Marlowe" writes: >> On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh >> wrote: >>> SQL execution failed, Internal error. SQL Statement: (COPY command failed >>> with error: ERROR: row is too big: size 8200, maximum size 8136) > >> Hmmm