I can only reproduce this error on windows 2000, on all other operating systems it works fine. Sometimes I see "No buffer space available error", other times I see "Socket not open error". In the database, besides other tables we have one table that contains bytea type columns, we see the above error when the copy command is executed for this table. I put in some print statements in socket.c, it looks like the pgwin32_recv() call times out waiting to read from the send buffer. Since the execution of the query at the server for the table containing bytea columns takes long time, there is nothing at the server side buffer to send to the recv side which just times out and throws socket not open error. I do not understand the inner working of the recv() and send() data transfer. Can someone explain it?. Also has any one else has seen this problem? Thanks. ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag
