> I created a big bytea value and try to select it from a table, I get > an error, something like: "ERROR: invalid memory alloc request size > ...". > it means i can insert data into table but then i can't even work > with it. is it a bug? could you please help me to solve this Problem. > Thank you very much for your support
This is a known (but not documented as far as I know) issue, but it also depends on the data contents and how the value is retrieved. Possible workarounds:
1. If the data is largely printable ASCII, then try setting "bytea_output" to "escape":