On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
> Arnaud Lesauvage <thewild@freesurf.fr> writes:
> > When trying to import a 20M rows csv file into PostgreSQL, I
> > get :
>
> > ERROR: out of memory
> > État SQL :53200
> > Détail :Failed on request of size 1073741823.
> > Contexte : COPY tmp, line 1
>
> Can you put together a self-contained example? The reference to "line
> 1" suggests that you wouldn't need the whole 20M row file, just the
> first few rows ...
Maybe it's a line termination problem?
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.