"Brodie Thiesfield" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
