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

From Gregory Stark
Subject Re: BUG #3520: insert causing error "invalid memory alloc request size 2147483648"
Date
Msg-id 87ps1ziqd9.fsf@oxford.xeocode.com
Whole thread Raw
In response to BUG #3520: insert causing error "invalid memory alloc request size 2147483648"  ("Brodie Thiesfield" <brofield2@jellycan.com>)
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

pgsql-bugs by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #3520: insert causing error "invalid memory alloc request size 2147483648"