The following bug has been logged online:
Bug reference: 2694
Logged by: Vitali Stupin
Email address: Vitali.Stupin@ria.ee
PostgreSQL version: 8.1.4
Operating system: sparc-sun-solaris2.10
Description: Memory allocation error when selecting array of empty
arrays
Details:
The error "invalid memory alloc request size 4294967293" apears when
selecting array of empty arrays:
select ARRAY['{}'::text[],'{}'::text[]];
This bug can be also reproduced on:
PostgreSQL 8.1.3 on sparc-sun-solaris2.10;
PostgreSQL 8.1.3 on i686-pc-linux-gnu.
The only difference is that linux version of postgre is trying to allocate
4294967294 (or 2^32 - 2) bytes.
...Sorry for posting the same bug report for the second time, but the
previous post sent almost a month ago (bug reference 2641) still had not
appeared in bug-list.