On Wednesday 19 July 2006 12:22, Fabian Groffen wrote:
If you do, it would be great if you could implement it in such a way that matches our TODO on this process.
Sjoerd already gave you pointers on how to get started coding. Enjoy!
:)
I began coding already :D It doesn't seem too hard, in fact, I already have a preliminary version where I don't have to specify the number of records beforehand (and only a few lines of code). I don't like it much, though, so I think its better to consult the list before even trying to clean it up. On my cvs checkout Niels Nes' suggestion: ========== The 'copy into' should work but it should be part of your generated output. The stream should generated COPY opt_nr INTO qname FROM STDIN opt_seps data empty_line ========== didn't work, perhaps I checked out a wrong branch. However, it was easy to make it work, and that is what I coded (make the copy end if either an empty line is found, or the opt_nr records have been inserted). The reason I don't like it much is that I don't know if empty_line had some semantics before that and I'm changing it. I had been also thinking of adding a third (optional) opt_seps, with a sensible default (empty_line?), that would let me specify what will be the <<end of input>> marker, but it seems I cannot do that without getting deep (changing the mvc_create_table function's signature even). So, what would be better? Leave it with 'empty_line' (easy and almost there), make up another marker (postgres uses \.), or try to add the third opt_seps? What branch should I checkout? Regards, Zarrabeitia (eager to feed my 2 million row database to Monetdb).