Re: Reg: SQL Query for Postgres 8.4.3

Поиск
Список
Период
Сортировка
От Srinivas Naik
Тема Re: Reg: SQL Query for Postgres 8.4.3
Дата
Msg-id z2l2e482c091005040446ne756a087z924832712bbe63a1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reg: SQL Query for Postgres 8.4.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: Reg: SQL Query for Postgres 8.4.3
Список pgsql-hackers
Дерево обсуждения
Hi Mark,

    Please find the below details:

postgresql-8.3

and UBUNTU-8.10 with linux-image-2.6.27.18-standard_810_i386.deb

and its an 32bit Ubuntu.



On Tue, May 4, 2010 at 9:02 AM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:
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



В списке pgsql-hackers по дате отправления: