On Fri, Feb 24, 2012 at 4:01 AM, Naoko Reeves <naokoreeves@xxxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
