The following bug has been logged online: Bug reference: 2694 Logged by: Vitali Stupin Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend