Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Adrian Klaver
On Tuesday 11 November 2008 6:31:04 pm Adrian Klaver wrote: > 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

Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Adrian Klaver
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

Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Glen Beane
On 11/11/08 9:09 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > Glen Beane <[EMAIL PROTECTED]> writes: >> On 11/11/08 2:25 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: >>> The most direct evidence about why it's stuck would probably be had by >>> attaching to the backend process with gdb and getting

Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Tom Lane
Glen Beane <[EMAIL PROTECTED]> writes: > On 11/11/08 2:25 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: >> The most direct evidence about why it's stuck would probably be had by >> attaching to the backend process with gdb and getting a stack trace. > It wasn't built with debugging symbols so there is

Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Glen Beane
On 11/11/08 2:25 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > The most direct evidence about why it's stuck would probably be had by > attaching to the backend process with gdb and getting a stack trace. It wasn't built with debugging symbols so there is some missing info, but here is what I ge

Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Glen Beane
On 11/11/08 2:25 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > Glen Beane <[EMAIL PROTECTED]> writes: >> I am using the copy_from command from the python psycopg2 library to do some >> bulk data loading of a postgres database. This had been working OK, until >> my script barfed because I was bei

Re: [GENERAL] Problem using COPY command to load data

2008-11-11 Thread Tom Lane
Glen Beane <[EMAIL PROTECTED]> writes: > I am using the copy_from command from the python psycopg2 library to do some > bulk data loading of a postgres database. This had been working OK, until > my script barfed because I was being careless, and it seemed to leave the > database in a strange stat

[GENERAL] Problem using COPY command to load data

2008-11-11 Thread Glen Beane
I'm not sure if this is the write place to post this question or not, but I hope someone can help me out. I am using the copy_from command from the python psycopg2 library to do some bulk data loading of a postgres database. This had been working OK, until my script barfed because I was being car