Re: BUG #3520: insert causing error "invalid memory alloc request size 2147483648"

"Brodie Thiesfield" <brofield2(at)jellycan(dot)com> writes:

> (at time of final INSERT)
> ERROR: XX000: invalid memory alloc request size 2147483648
> LOCATION: MemoryContextAlloc, mcxt.c:504

Some questions: what encoding was the database created in? And what locale is
your server running in?

The commands which would be useful to answer the above are:

postgres=# \l
List of databases
Name | Owner | Encoding
-----------+-------+-----------
postgres | stark | SQL_ASCII
template0 | stark | SQL_ASCII
template1 | stark | SQL_ASCII
(3 rows)

postgres=# show all;
name | setting | description
---------------------------------+--------------------------------+-------------------------------------------------------------------------------------------------------------------------------
add_missing_from | off | Automatically adds missing table references to FROM clauses.
...

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com