Nik wrote:
have an SQL file with a set of about 3000 insert statements. This
file is executed twice from a remote client machine running Windows
XP. The first time it is executed against a Windows 2003 Server
running PostgreSQL 8.0. The second time it is executed against a
Windows 2003 Server running PostgreSQL 8.2. This setup has been in
place for about a year now and never had any issues.
However, I noticed today that all the file executions fail with
[nativecode=could not send data to server: No buffer space available
(0x00002747/10055)] error.
I attempted to run the same file using pgAdmin III version 1.6.2, but
every time the file is executed the only return in messages pane is
the colon sign ":". No data is inserted.
I attempted to run the same file using psql.exe and this worked
without any problems.
I also noticed that if I use less inserts, for example only a few
hundred, the file executes fine.
What could be the issue?
First, this is the wrong place to ask this question. pgsql-hackers is
about development of postgres itself, not about usage questions. Perhaps
you should ask on pgsql-general.
Second, if you can run the file using psql, then it does not appear to
be a problem with postgres at all, but rather with the client you are
using (you don't say what that client is). Perhaps your client is trying
a naive method of batching inserts and thus running out of buffer space
- it's hard to tell since you haven't given much information.
In the case of pgAdminIII, you might need to ask on its lists.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
