Re: BUG #3520: insert causing error "invalid memory alloc request size 2147483648" - Mailing list pgsql-bugs

"Brodie Thiesfield" <brofield2@jellycan.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