BYTEA data type problem

From: "Shkola, Roman" <roman(dot)shkola(at)siemens(dot)com>
To: "support(at)enterprisedb(dot)com" <support(at)enterprisedb(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Cc: "vigen(dot)stepanian(at)siemens(dot)com" <vigen(dot)stepanian(at)siemens(dot)com>, "Freudenberger, Peter" <peter(dot)freudenberger(at)siemens(dot)com>
Subject: BYTEA data type problem
Date: 2018-11-21 10:24:12
Message-ID: AM4PR1001MB1284080FE140548F158BFE779CDA0@AM4PR1001MB1284.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

There is written in the documentation, that PostgreSQL is able to work with files stored in BYTEA column up to 1GB.
It is possible to write such a huge file there, but not read it then.
I always get an exception:

ERROR: invalid memory alloc request size 18446744072511736321
SQL state: XX000

Any solution?

With best regards,
Bc. Roman Shkola

Siemens, s.r.o.
RC-CZ MO EN-SW
Siemensova 1
155 00 Praha, Czech Republic
Mobile: +420 727 909 714
mailto:roman(dot)shkola(at)siemens(dot)com
[www.siemens.com/ingenuityforlife]

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-11-21 13:21:33 BUG #15515: DatabaseMetadata.getProcedures and getFunctions return objects of either type
Previous Message Adrien Nayrat 2018-11-21 08:09:36 Re: ALTER INDEX ... ALTER COLUMN not present in dump