Re: Reg: SQL Query for Postgres 8.4.3

On 04/05/10 18:47, Srinivas Naik wrote:

Hi,

 

 Can any one tell me whats the effect of the below Query

 

SELECT substring(B'1111000000000001' from 5 for -2);

SELECT substring(B'1111000000000001' from 4 for -3);

 

its observed that there's an Error "invalid memory alloc request size 4244635647"

 

What will actually happen to the Postgresql database.

 

I am using Postgresql 8.4.3 on Ubuntu 8.04

 

 
I can reproduce this with 8.4.*2* on Ubuntu 10.04 32-bit (postgres built from src) but *not* with 8.4.*3*. Can you double check it is 8.4.3 you are using? and if so tell us whether you are using 32 or 64 bit Ubuntu!

Cheers

Mark