BUG #14497: 1G bytea insert error

The following bug has been logged on the website:

Bug reference: 14497
Logged by: Nikolay Nikitin
Email address: nikolay(dot)nikitin(at)infowatch(dot)com
PostgreSQL version: 9.4.10
Operating system: Red Hat Enterprise Linux Server release 6.7
Description:

Hi! I try to insert 1G bytea value into the simple table and get the
error.

drop table if exists test;

create table test
(
blob bytea
);

insert into test(blob) select string_agg(gen_random_bytes(1024 - case when g
= 1024 then 52 else 0 end), null::bytea)::bytea from generate_series(1, 1024
* 1024) g;

ERROR: invalid memory alloc request size 1073741824
********** Ошибка **********

ERROR: invalid memory alloc request size 1073741824
SQL-состояние: XX000

Value equal or greater 1G-52 raises the error. But smaller value inserts
without errors.

insert into test(blob) select string_agg(gen_random_bytes(1024 - case when g
= 1024 then 53 else 0 end), null::bytea)::bytea from generate_series(1, 1024
* 1024) g;
Query returned successfully: one row affected, 02:04 minutes execution
time.

I think 1G has to be inserted without errors.

Regards, Nikolay.