From: | "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Invalid memory alloc request size |
Date: | 2006-07-11 21:29:40 |
Message-ID: | 1E293D3FF63A3740B10AD5AAD88535D233E68E@UBIMAIL1.ubisoft.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I'm using PostgreSQL 8.1.4 on a Linux 2.6.8-2-686-smp machine, 2 Go
memory. I have a strange error "invalid memory alloc request size",
when I perform the following query:
=> select * from player where lower(username) = 'wario';
ERROR: invalid memory alloc request size 1918988375
where player contains a bit more than 1 million records, username is a
character varying(255) not null.
I have strictly no idea about what goes wrong here. Whatever operation
I try to apply on the column username's value (lower, upper, length)
raises such an error.
I searched for some similar cases in the pgsql-sql archive but nothing
really similar. Any idea?
Regards,
P.S.: I don't have this problem on other tables containing less data.
--
Daniel CAUNE
Ubisoft Online Technology
(514) 490 2040 ext. 3613
From | Date | Subject | |
---|---|---|---|
Next Message | aurora | 2006-07-12 00:47:31 | Unexpected SQL error for UPDATE |
Previous Message | Richard Broersma Jr | 2006-07-11 17:03:39 | Re: How to find entries missing in 2nd table? |