From: | "Kafka" <kafka(at)centras(dot)lt> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | my application |
Date: | 2002-11-03 21:26:32 |
Message-ID: | 003001c2837f$ae5bc410$4801000a@nasa |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
sorry, if this question must be in another group.
I use Visual C++ and driver, connect to PostgeSQL.
Application works fine, but some time I have problem.
My application read data from another SQL server and tranfers to
PostgreSQL server. But sometime, my client hangs up, when it makes
new inset to PostgreSQL.
Maybe I over fill server buffer and I must clear it?
After each 100 insert I make PQreset(m_conn);
But this don't help and sometime, when I use this:
if (!m_res || PQresultStatus(m_res) != PGRES_COMMAND_OK)
{
wevent(strSQL);
PQclear(m_res);
m_res = PQexec(m_conn, "ABORT") ;
PQclear(m_res);
return 17;
}
application gets hangs up.
I don't get error and it don't return 17. My program stay and do nothing.
If I try insert this record with pgamin, it will also hangs up.
If I reboot postgreSQL server, it will works fine and I can run my
application
and it can insert this record and go.
Thanks for answers.
Dz.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-04 02:07:06 | Re: Is my Internet connection slow |
Previous Message | Bruce Momjian | 2002-11-03 18:31:36 | Is my Internet connection slow |