Re: invalid memory alloc request size 1765277700 Error Question

On Fri, Feb 24, 2012 at 4:01 AM, Naoko Reeves <naokoreeves(at)gmail(dot)com> wrote:
> -- I have narrowed down the row
> SELECT * FROM table ORDER BY table_id OFFSET 526199 LIMIT 1  -- ERROR:
> invalid memory alloc request size 1765277700

Are you certain that offset 526199 is using both the same query plan
and doesn't produce this error?

> -- I was able to view a few columns
> SELECT table_id, table_column1, table_column2 FROm table ORDER BY table_id
> OFFSET 526199 LIMIT 1 -- returns one row table_id = 12345
> -- using that id to SELECT ALL. It shows fine...I was assuming this will
> give me same error...
> SELECT * FROM table WHERE table_id=12345  -- shows perfectly
> -- This also returns value just fine
> SELECT table_column3 FROM table WHERE table_id =  12345
> -- However this returns an error
> SELECT table_column3 FROm table ORDER BY table_id OFFSET 526199 LIMIT 1
> --error  ERROR:  invalid memory alloc request size 1765277700

If you do select <col_list> from table

where col_list is all cols except col3 do you get the error? What
type of col is col3?