Alvaro Herrera writes:
Can you send the program along? And the table definition (including
indexes, etc)?
I put the table definition and a Python program that reproduces the problem
at:
http://public.natserv.net/table-schema.sql
http://public.natserv.net/large_record.py
The program uses the psycopg2 library.
All the program does is to send test data to the table, in particular doing
a large text size for a text column called attachment_body.
The database doesn't give an out of error message like when trying to run a
copy, but instead generates a lot output to the log such as
http://public.natserv.net/postgresql-2007-06-19.txt
The out of memory error when trying to use the copy command is
http://public.natserv.net/postgresql-2007-06-15.log
Thanks for any further pointers and suggestions.
Don't know what else to try at this point.
