[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

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

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh sbhuj...@starentnetworks.com 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

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Tom Lane
Scott Marlowe scott.marl...@gmail.com writes: On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh sbhuj...@starentnetworks.com 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

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 12:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: Scott Marlowe scott.marl...@gmail.com writes: On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh sbhuj...@starentnetworks.com wrote: SQL execution failed, Internal error. SQL Statement: (COPY command failed with error: ERROR: