Обсуждение: COPY Support Patch - actualized version?
Hi, I'm currently trying to apply the COPY patch from http://archives.postgresql.org/pgsql-jdbc/2003-12/msg00186.php but it seems that it doesn't work cleanly. Does someone have an updated version ready? I'm currently trying to dig into the code myself, but reinventing the wheel is not my primary pleasure :-) Thanks, Markus -- markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 zürich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com
On Thu, 24 Jun 2004, Markus Schaber wrote: > Hi, > > I'm currently trying to apply the COPY patch from > http://archives.postgresql.org/pgsql-jdbc/2003-12/msg00186.php but it > seems that it doesn't work cleanly. > > Does someone have an updated version ready? I'm currently trying to dig > into the code myself, but reinventing the wheel is not my primary > pleasure :-) > Steve Wampler claimed to have it working recently here: http://archives.postgresql.org/pgsql-jdbc/2004-06/msg00034.php I imagine he patched the 7.4 branch driver instead of the cvs version. Merging this with the latest cvs code will be a waste of time as a monster patch implementing full V3 protocol support will soon be applied and it will need to be remerged. Once this patch is settled in I'll produce an updated copy patch. Kris Jurka
Hi @all, I attached a little utility class that may be of use for all those "COPY table FROM" users. It may be used with a ByteArrayOutputStream when the amount of data is small enough to get buffered in RAM, with a PipedOutputStream for fully featured Piping of Data (when your pgjdbc version supports it) or even with a FileOutputStream when your Java App just creates feed for psql. Currently, it's rather untested and not well commented, but this will improve, especially when lots of constructive feedback reaches my inbox :-) Happy Hacking, Markus Schaber -- markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 zürich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com