Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem using COPY command to load data - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Problem using COPY command to load data
Date
Msg-id 200811111831.05207.aklaver@comcast.net
Whole thread Raw
In response to Re: Problem using COPY command to load data  (Glen Beane <Glen.Beane@jax.org>)
Responses Re: Problem using COPY command to load data  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view 
On Tuesday 11 November 2008 6:20:09 pm Glen Beane wrote:

>
> Python with the psycopg2 library.  I swear this was working earlier today.
> Maybe I am imagining things :)
> It does work with a unix socket, and I have a deadline to meet, so for now
> I just need to make sure I am running this on the same host as the
>postgresqlserver

See these two posts for potential solution:
http://lists.initd.org/pipermail/psycopg/2008-October/006224.html
http://lists.initd.org/pipermail/psycopg/2008-October/006225.html

They point to a problem with ssl and psycopg2 COPY. Also I know there where
some problems with psycopg2 and copy that where fixed in psycopg2 version
2.0.7.
--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Avoiding seq scan over 3.2 millions rows
Next
From: Adrian Klaver
Date:
Subject: Re: Problem using COPY command to load data