On Fri, Feb 24, 2012 at 4:01 AM, Naoko Reeves <naokoreeves@gmail.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?