Hi warehouse friends,

I took a look at the adapter_extensions code for Postgres today - it's 
a great idea. I think the code you've got only works for loading files 
onto a file system accessible by the Postgres server? In a shared 
hosting environment this may surprisingly limited. I think most people 
would expect to be able to load files from anywhere visible to the 
client?

I have some Postgres sql code that permits bulk loading data via COPY, 
but using STDIN as the source, so you can feed it via a file on the 
client side, rather than from a server-accessible file. Of course it's 
not as fast as reading a file from a local SCSI array, but sending data 
to copy COPY over a network wire is way faster than any other remote 
technique I've found.

I'm happy to post this code to the list or to the code maintainer if 
it's of interest. Just let me know!

Sincerely,

Steve

_______________________________________________
Activewarehouse-discuss mailing list
Activewarehouse-discuss@rubyforge.org
http://rubyforge.org/mailman/listinfo/activewarehouse-discuss

Reply via email to