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

"Brodie Thiesfield"  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