Re: bytea columns and large values

On 28/09/11 01:50, Craig Ringer wrote:
> On 09/28/2011 01:01 AM, David North wrote:
>
>> testdb=# select * from problem_table;
>> ERROR: invalid memory alloc request size 2003676411
>
> What Pg version are you using?
>
> On which platform?
>
> 32-bit or 64-bit OS? If 64-bit, with a 32-bit or 64-bit build of
> PostgreSQL?

psql (PostgreSQL) 9.0.4

64 bit fedora:

Fedora release 14 (Laughlin)
Linux mybox 2.6.35.14-95.fc14.x86_64 #1 SMP Tue Aug 16 21:01:58 UTC 2011
x86_64 x86_64 x86_64 GNU/Linux

I presume my build of PostgreSQL is x64 - ldd `which psql` spits out
lots of references to lib64.

David


--
David North, Software Developer, CoreFiling Limited
http://www.corefiling.com
Phone: +44-1865-203192