Re: Error on PQputline()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Error on PQputline()
Date: 2002-05-17 23:37:49
Message-ID: 23355.1021678669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Dann Corbit" <DCorbit(at)connx(dot)com> writes:
>> You're running libpq with the nonblocking mode selected?

> Actually no. It should be the default mode for a connection made by
> PQconnectdb(). That's what made the error so puzzling.

I'm confused too. For starters, I cannot find that error message
string about 'A non-blocking socket operation could not be completed
immediately' anywhere. Got any idea what's producing that? Exactly
which version of libpq are you using, anyway?

> "Would it be faster to write a file to disk and read it again on the
> local host for the server or to send the calls via libpq client
> messages?"

Good question. I'd recommend the messaging approach since it eliminates
lots of headaches about file access privileges and so forth. But on
some platforms the overhead could be high.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dann Corbit 2002-05-17 23:41:34 Re: Error on PQputline()
Previous Message Tom Lane 2002-05-17 23:22:59 Re: Updated CREATE FUNCTION syntax