We have a 6.4 beta starting September 1, with final October 1. It is
possible that somehow there is a problem with 6.3.2 that I am not seeing
in the current sources. The new code that closes a file descriptor left
open from a failed COPY will be in there, so you should try that release
first.
> > OK, in pgsql/src/backend/command/copy.c, you should see a function call
> > to FreeFile(). That is what is supposed to be called to free the open
> > file. AllocateFile opens the file a few lines above it, in either read
> > or write mode.
> >
> > If you can, can you put a little printf statement just before the
> > FreeFile, and see if it is getting called. You have to look in the
> > postmaster log file to see the output of the printf(). If it is getting
> > called, I have no idea why it would still be holding the file
> > descriptor. If it is not calling that function, I am confused because I
> > can't see how it could get out of that function without calling it.
>
> I'm willing to have a look at this in a few weeks, but I don't have time
> to do it now. I'll get back to you when I've got some additional info.
>
> --
> Greg Black <gjb@acm.org>
>
>
>
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
