Postgres Pro
Downloads
Home   >   mailing lists

Re: Hang in PQgetResult - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Hang in PQgetResult
Date
Msg-id 244.1077311765@sss.pgh.pa.us
Whole thread Raw
In response to Hang in PQgetResult  ("Ivetta Starikova" <ivetta_s@hotmail.com>)
List pgsql-bugs
Tree view 
"Ivetta Starikova" <ivetta_s@hotmail.com> writes:
> I have a problem with my program that inserts records into postgreSQL
> database.
> After continuously running for several days, it suddenly hangs.

Looks to me like it's waiting for the server process.  Are you sure
there isn't some other operation blocking the INSERT (perhaps by
exclusively locking the table)?  If you're not sure what the server
is doing, try getting a stack trace from it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Joe Sunday
Date:
Subject: Re: Maybe a bug found with nextval() function
Next
From: Tom Lane
Date:
Subject: Re: date_part returns different results with same interval.